File: TODO.md

package info (click to toggle)
hypopg 1.4.2-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 464 kB
  • sloc: ansic: 2,338; sql: 357; makefile: 66; python: 51; sh: 2
file content (31 lines) | stat: -rw-r--r-- 860 bytes parent folder | download | duplicates (6)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
TODO
====

Important
---------

- [X] Choose a better naming convention, including the index oid
- [X] handle multiple columns
- [X] handle collation
- [ ] handle GIN access method
- [ ] handle GiST access method
- [ ] handle SP-GiST access method
- [X] handle BRIN access method
- [X] better formula for number of pages in index
- [ ] handle tree height
- [X] Add check for btree: total column size must not exceed BTMaxItemSize (maybe less, just in case?)
- Add some more (or enhance) function. Following are interesting:
- [X] estimated index size
- [ ] estimated number of lines
- [X] add hypopg_get_indexdef(oid)

Less important
--------------

- [ ] specify tablespace
- [ ] Compatibility PG 9.2-
- [X] handle unique index
- [X] handle reverse and nulls first
- [X] handle index on expression
- [X] handle index on predicate
- [ ] specify a bloat factor