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.
