Re: seq scan cache vs. index cache smackdown - Mailing list pgsql-performance

From Iain
Subject Re: seq scan cache vs. index cache smackdown
Date
Msg-id 001e01c5132b$48efbe40$7201a8c0@mst1x5r347kymb
Whole thread Raw
In response to seq scan cache vs. index cache smackdown  (Mark Aufflick <mark@pumptheory.com>)
List pgsql-performance
Hi Rod,

> Any solution fixing buffers should probably not take into consideration
> the method being performed (do you really want to skip caching a
> sequential scan of a 2 tuple table because it didn't use an index) but
> the volume of data involved as compared to the size of the cache.

Yes, in fact indexes aren't so different to tables really in that regard.

It sounds like version 8 may help out anyway.

regards
Iain

pgsql-performance by date:

Previous
From: "Iain"
Date:
Subject: Re: VACCUM FULL ANALYZE PROBLEM
Next
From: Greg Stark
Date:
Subject: Re: seq scan cache vs. index cache smackdown