On Wed, Oct 12, 2011 at 4:26 PM, Kevin Grittner <kevin.gritt...@wicourts.gov> wrote: >> But it matters a *lot* when they heap pages are not in shared >> buffers > > Yeah, obviously it matters more if you actually need to add a random > disk read.
To be fair the indexes are also random I/O. So the case that really matters is when the index fits in RAM but the heap does not. -- greg -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
