This is a discussion on pgsql: A couple of tiny performance hacks in _bt_step(). within the pgsql Committers forums, part of the PostgreSQL category; --> Log Message: ----------- A couple of tiny performance hacks in _bt_step(). Remove PageIsEmpty checks, which were once needed because ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Log Message: ----------- A couple of tiny performance hacks in _bt_step(). Remove PageIsEmpty checks, which were once needed because PageGetMaxOffsetNumber would fail on empty pages, but are now just redundant. Also, don't set up local variables that aren't needed in the fast path --- most of the time, we only need to advance offnum and not step across a page boundary. Motivated by noticing _bt_step at the top of OProfile profile for a pgbench run. Modified Files: -------------- pgsql/src/backend/access/nbtree: nbtsearch.c (r1.97 -> r1.98) (http://developer.postgresql.org/cvsw...1=1.97&r2=1.98) ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org |
| Thread Tools | |
| Display Modes | |
|
|