On Mon, Nov 08, 2010 at 07:19:43PM +0100, Jakub Ouhrabka wrote: > Hi, > > we have several instances of following error in server log: > > 2010-11-08 18:44:18 CET 5177 1 @ ERROR: out of memory > 2010-11-08 18:44:18 CET 5177 2 @ DETAIL: Failed on request of size 16384. > > It's always the first log message from the backend. We're trying to > trace it down. Whether it's always connection attempt to the same > database or not - I don't know at the moment. > > Sometimes the error message is preceded by memory stats which are > below in the email. > > Other relevant data: > Linux, PostgreSQL 8.2.10 > RAM 28GB > > max_connections = 2048 > > shared_buffers = 2048MB > > temp_buffers = 32MB > max_prepared_transactions = 0 > > max_fsm_pages = 10000000 > max_fsm_relations = 100000 is it 32bit or 64bit machine? what's the work_mem? Best regards, depesz -- Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/ jid/gtalk: depesz@xxxxxxxxxx / aim:depeszhdl / skype:depesz_hdl / gg:6749007 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
