From: | Együd Csaba <csegyud(at)vnet(dot)hu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Insufficient memory for this operation. |
Date: | 2004-12-14 08:49:59 |
Message-ID: | 0I8P00J8WF74CB@mail.vnet.hu |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
(WinXP, PG8b5, 1GB, 3,2GHz)
Hi,
I regulary get the above error message when I run my applications in
parallel. There are minimum of 5 applications which have to access the
server in parallel, but in the production environment this number will about
30-50 (with the additional clients). Each of them connects to the server
(here comes the error message), runs a query and disconnects.
If one of them is stopped, then everything works well, but 5 applications
seem to be too large.
I monitor the PGAdmin Server Status window. It shows that maximum 2
connections are concurrent in the same time, not more.
My postgresql.conf file:
max_connections = 100
shared_buffers = 20000 # min 16, at least max_connections*2, 8KB
each
work_mem = 16384 # min 64, size in KB
maintenance_work_mem = 16384 # min 1024, size in KB
max_stack_depth = 2048 # min 100, size in KB
(The NT Task Manager reports a 769MB memory usage.)
What should I increase/decrease to acheave the required performance? Or what
do I do wrong?
Many thanks,
-- Csaba Együd
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com)
Version: 6.0.805 / Virus Database: 547 - Release Date: 2004.12.03.
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2004-12-14 09:34:12 | Re: Help needed with QueryPlan |
Previous Message | JM | 2004-12-14 08:33:34 | Re: Spanning tables |