On Wed, 12 Nov 2008, Grzegorz JaĆ~[kiewicz wrote:
that's on 8.3, by default there was no sort_mem , I hadded it , changed it to 512MB and all of the sudent everything started to fly - wherever it required hudge ammounts of memory for queries. The queries are reports, so they basicaly join few tables, and dump all ofthat content - so it takes a bit of a memory to do it ;)
Be advised that the work_mem setting (and its deprecated alias sort_mem) are on a per-client basis. So if you have a bunch of people running reports with that setting, you might discover your server running out of memory; that's a really high setting. Generally, if it's only a report or two that need a lot more working memory for sorts, you can do this at the beginning of them instead:
set work_mem='512MB'; Which will set the value only for that session. -- * Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
