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

From Kevin Grittner
Subject Re: How does PG know if data is in memory?
Date
Msg-id 4CA324CD0200002500036117@gw.wicourts.gov
Whole thread Raw
In response to How does PG know if data is in memory?  (Fabrício dos Anjos Silva<fabricio.silva@linkcom.com.br>)
List pgsql-performance
Fabrício dos Anjos Silva<fabricio.silva@linkcom.com.br> wrote:

> After reading lots of documentation, I still don't understand
> fully how PG knows if some needed data is in memory or in second
> storage.

> Does PG consider this?

No.

> When setting seq_page_cost and random_page_cost, do I have to
> consider the probability that data will be in memory?

Yes.

-Kevin

pgsql-performance by date:

Previous
From: Fabrício dos Anjos Silva
Date:
Subject: How does PG know if data is in memory?
Next
From: Fabrício dos Anjos Silva
Date:
Subject: Wrong index choice