Insufficient memory for this operation.

(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.