Postgres performance problem

Поиск
Список
Период
Сортировка
От Ruben Rubio
Тема Postgres performance problem
Дата
Msg-id 46D2B879.6010308@rentalia.com
обсуждение исходный текст
Ответы Re: Postgres performance problem  (Chris Mair <chris@1006.org>)
Список pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



Hi,

Note: I have already vacumm full. It does not solve the problem.

I have a postgres 8.1 database. In the last days I have half traffic
than 4 weeks ago, and resources usage is twice. The resource monitor
graphs also shows hight peaks (usually there is not peaks)

The performarce is getting poor with the time.

Im not able to find the problem, seems there is not slow querys ( I have
log_min_duration_statement = 5000 right now, tomorrow I ll decrease it )

Server is HP, and seems there is not hardware problems detected.

Any ideas to debug it?



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFG0rh5Io1XmbAXRboRAuaTAJ4tDVHUMN5YRBdWxT//kPAfBvYqRACgvLst
rJF3dmxzWHDOWB8yQwTyvpw=
=2ic9
-----END PGP SIGNATURE-----

Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Adam Tauno Williams
Дата:
Сообщение: Re: Shared memory usage
Следующее
От: "Max Zorloff"
Дата:
Сообщение: Re: Shared memory usage