Postgres Pro
Downloads
Home   >   mailing lists

postgres getting slow - Mailing list pgsql-general

From Brian
Subject postgres getting slow
Date
Msg-id Pine.LNX.4.10.9905131752430.12408-100000@mercury.shreve.net
Whole thread Raw
Responses Re: [GENERAL] postgres getting slow  ("Brett W. McCoy" <bmccoy@lan2wan.com>)
List pgsql-general
Tree view 
I noticed that on our postgres server, when more than say 15-20 backends
are open at once, things start to get real slow.  System is:

Redhat 5.2 Linux
2.2.8 kernel
Postgres 6.3.2
PII 450
256MB RAM

Does anyone know why this may be?

Also I can't seem to get postgres to write to a log about what it is
doing, whats the best way to get it to do this, so that any
errors/warnings get logged?

Brian


-----------------------------------------------------
Brian Feeny (BF304)     signal@shreve.net
318-222-2638 x 109    http://www.shreve.net/~signal
Network Administrator   ShreveNet Inc. (ASN 11881)

pgsql-general by date:

Previous
From: Dustin Sallings
Date:
Subject: Re: [GENERAL] Optimizations for busy DB??
Next
From: Tom Lane
Date:
Subject: Re: backend dies suddenly after a lot of error messages