Re: How does PG know if data is in memory? - Mailing list pgsql-performance

From Pierre C
Subject Re: How does PG know if data is in memory?
Date
Msg-id op.vjwgh8ejeorkce@apollo13
Whole thread Raw
In response to Re: How does PG know if data is in memory?  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-performance
> It sounds horrendously complicated to keep track of to me, and in the
> end it won't make query execution any faster, it'll just potentially
> help the planner pick a better plan. I wonder if that'd be worth the
> extra CPU time spent managing the cache and cache content stats, and
> using those cache stats when planning? It'd be an interesting
> experiment, but the outcome is hardly obvious.

Well, suppose you pick an index scan, the only way to know which index
(and heap) pages you'll need is to actually do the index scan... which
isn't really something you'd do when planning. So you scan,

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: How does PG know if data is in memory?
Next
From: Fabrício dos Anjos Silva
Date:
Subject: Re: How does PG know if data is in memory?