This is a discussion on pgsql: Suppress useless searches for unused line pointers in within the pgsql Committers forums, part of the PostgreSQL category; --> Log Message: ----------- Suppress useless searches for unused line pointers in PageAddItem. To do this, add a 16-bit "flags" ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Log Message: ----------- Suppress useless searches for unused line pointers in PageAddItem. To do this, add a 16-bit "flags" field to page headers by stealing some bits from pd_tli. We use one flag bit as a hint to indicate whether there are any unused line pointers; the remaining 15 are available for future use. This is a cut-down form of an idea proposed by Hiroki Kataoka in July 2005. At the time it was rejected because the original patch increased the size of page headers and it wasn't clear that the benefit outweighed the distributed cost. The flag-bit approach gets most of the benefit without requiring an increase in the page header size. Heikki Linnakangas and Tom Lane Modified Files: -------------- pgsql/doc/src/sgml: storage.sgml (r1.14 -> r1.15) (http://developer.postgresql.org/cvsw...1=1.14&r2=1.15) pgsql/src/backend/storage/page: bufpage.c (r1.71 -> r1.72) (http://developer.postgresql.org/cvsw...1=1.71&r2=1.72) pgsql/src/include/catalog: catversion.h (r1.388 -> r1.389) (http://developer.postgresql.org/cvsw...1.388&r2=1.389) pgsql/src/include/storage: bufpage.h (r1.71 -> r1.72) (http://developer.postgresql.org/cvsw...1=1.71&r2=1.72) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |
| Thread Tools | |
| Display Modes | |
|
|