On Thu, Dec 12, 2013 at 12:18 PM, knizhnik <knizh...@garret.ru> wrote: > IMHO it is strange to see such small default values in postgresql > configuration.
This (low default work mem) is because of three things: 1) Most queries do not really need a lot of work mem 2) Work mem stacks with each query using it -- so with your 1mb setting vs 1000 connections, you get a gigabyte. So, some conservatism is justified although this setting tended to be much more dangerous in the old days when we measured memory in megabytes. 3) Postgres does not query available physical memory for default settings due to portability issues. So we tend to tune to "common denominator". merlin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
