> Server is a dual xeon with a gig of ram dedicated mostly to postgresql.
> Here is the changed lines in my postgresql.conf: http://pastebin.ca/57222
3M is really low for a production server.
Try using pg_pool and limiting it to about 30 or so backend connections,
and then give them at least 30 megs of RAM each.
This should also cut down the connection creation overhead.
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
In response to
pgsql-performance by date
|Next:||From: Meetesh Karia||Date: 2006-05-22 17:20:09|
|Subject: Query hanging/not finishing inconsistently|
|Previous:||From: Jim C. Nasby||Date: 2006-05-22 15:30:08|
|Subject: Re: Performs WAY better with enable_seqscan = off|