I'll add one more observation here:
On Tue, 25 Jun 2002, Markus Wollny wrote:
> wal_buffers = 32
> wal_files = 64
Everyone else already mentioned the shared mem and sort mem, but I've
found that while increasing wal_buffers and wal_files helps, 64 WAL files
is probably overkill.
I'd suggest the strategy to take your postgresql.conf file to stock, run a
dozen or so slow queries at once, then make ONE CHANGE at a time and see
how much of a difference it makes.
And remember, just because a little helps does NOT mean a lot will. Often
it's the first change that makes the biggest difference.
--
"Force has no place where there is need of skill.", "Haste in every
business brings failures.", "This is the bitterest pain among men, to have
much knowledge but no power." -- Herodotus