Re: how smart is is pg with shared_buffers? - Mailing list pgsql-general

From Joseph Shraibman
Subject Re: how smart is is pg with shared_buffers?
Date
Msg-id 3F710695.1010704@selectacast.net
Whole thread Raw
In response to how smart is is pg with shared_buffers?  (Joseph Shraibman <jks@selectacast.net>)
Responses Re: how smart is is pg with shared_buffers?
List pgsql-general
Joseph Shraibman wrote:
> Does pg know to keep indexes in memory and release table data?  Does it
> use an lru algorithm or does it know that certain tables are hit more
> often and others and should be given prefrence?

And when it has to do a seq scan on a table does it start with what is in the cache before
it goes to the os to read from the disk?


pgsql-general by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: "Expiring" transactions?
Next
From: Bruce Momjian
Date:
Subject: Re: Bug while installing in AIX 5.1