Hi, >For cluster-wide setting you will probably want to drop that significantly -- >start lower, as in somewhere around 10MB >and work up from there as necessary. >For the queries you are finding slow (the reason for these emails) you can set >>work_mem specifically for the session.
>Eg. >set work_mem to '400MB'; ><run your query> >reset work_mem; I changed it to 10MB. The problamatic commands runs now less than 10 seconds. http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server wrote that max reasonable value in Windows for shared_buffers is 512MB Is my setting shared_buffers= 2400MB reasonable in Windows ? Andrus.
