Scott Carey wrote:
> For reads, if your shared_buffers is large enough, your heavily used
> indexes won't likely go to disk much at all.
ISTM this would happen regardless of your shared_buffers setting.
If you have enough memory the OS should cache the frequently used
pages regardless of shared_buffers; and if you don't have enough
memory it won't.
> ... splitting up data and indexes ...
FWIW, I've had a system where moving pgsql_tmp to different disks
helped more than moving indexes.
In response to
pgsql-performance by date
|Next:||From: André Volpato||Date: 2008-08-21 20:05:12|
|Subject: Re: Postgres not using array|
|Previous:||From: Tom Lane||Date: 2008-08-21 19:10:18|
|Subject: Re: Postgres not using array |