On Wed, Oct 12, 2011 at 4:26 PM, Kevin Grittner <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
