This is a discussion on pgsql: Add all heap page rows visible bitmap idea: < the heap. within the pgsql Committers forums, part of the PostgreSQL category; --> Log Message: ----------- Add all heap page rows visible bitmap idea: < the heap. One way to allow this ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Log Message: ----------- Add all heap page rows visible bitmap idea: < the heap. One way to allow this is to set a bit to index tuples > the heap. One way to allow this is to set a bit on index tuples < be cleared when a heap tuple is expired. < > be cleared when a heap tuple is expired. Another idea is to maintain > a bitmap of heap pages where all rows are visible to all backends, > and allow index lookups to reference that bitmap to avoid heap > lookups, perhaps the same bitmap we might add someday to determine > which heap pages need vacuuming. Modified Files: -------------- pgsql/doc: TODO (r1.1708 -> r1.1709) (http://developer.postgresql.org/cvsw...1708&r2=1.1709) pgsql/doc/src/FAQ: TODO.html (r1.215 -> r1.216) (http://developer.postgresql.org/cvsw...1.215&r2=1.216) ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings |
| Thread Tools | |
| Display Modes | |
|
|