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

From Tom Lane
Subject Re: How does PG know if data is in memory?
Date
Msg-id 12383.1285944011@sss.pgh.pa.us
Whole thread Raw
In response to Re: How does PG know if data is in memory?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> I agree with that, but I think there's an even more insidious issue
> here.  Biasing plans heavily toward using what is already in cache
> could have a destabilizing effect on performance.

Not to mention the destabilizing effect on the plans themselves.
Behavior like that would make EXPLAIN nearly useless, because the plan
you get would vary from moment to moment even when "nothing is
changing".  It's fairly clear that people don't actually want that.

            regards, tom lane

pgsql-performance by date:

Previous
From: Fabrício dos Anjos Silva
Date:
Subject: Re: How does PG know if data is in memory?
Next
From: Merlin Moncure
Date:
Subject: Re: gist indexes for distance calculations