During Robert Haas’s talk (slides) last week at PGCon, I realized that three of our major performance features for Postgres 9.2 involved representing data in a more compact form:
- Allow queries to retrieve data only from indexes, avoiding heap access
- Allow hint bits to be set sooner
- Move the frequently accessed members of the PGPROC shared memory array to a separate section, for performance
The first item reduces disk reads, the second reduces memory reads, and the third reduces CPU cache line accesses.
If you're new here, you may want to subscribe to our RSS feed or follow us on Twitter for product announcements, event information, and industry news.
Speeding Up by Condensing
