Re: Permance issues with migrated db - Mailing list pgsql-general

Robert Fitzpatrick wrote:
> I did some googling and came up with some ideas, I have it now with
> these settings and after restarting PG, no help.
>
> work_mem = 5MB

My last post missed yours - you're ahead of my previous reply :-)

Try 32MB, then 64MB, then perhaps 128MB. If it looks like you're not
using stupid amounts of RAM on this one sort go higher still.

--
   Richard Huxton
   Archonet Ltd