Re: How does PG know if data is in memory?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Fabrício dos Anjos Silva<fabricio.silva@xxxxxxxxxxxxxx> 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

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux