(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. ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
