> is it 32bit or 64bit machine?
64bit
> what's the work_mem?
64MB
Kuba
Dne 8.11.2010 19:52, hubert depesz lubaczewski napsal(a):
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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
