postgres getting slow

Поиск
Список
Период
Сортировка
От Brian
Тема postgres getting slow
Дата
Msg-id Pine.LNX.4.10.9905131752430.12408-100000@mercury.shreve.net
обсуждение исходный текст
Ответы Re: [GENERAL] postgres getting slow  ("Brett W. McCoy" <bmccoy@lan2wan.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Dustin Sallings
Дата:
Сообщение: Re: [GENERAL] Optimizations for busy DB??
Следующее
От: Tom Lane
Дата:
Сообщение: Re: backend dies suddenly after a lot of error messages