Re: Periodic bottle-neck in high load app

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Periodic bottle-neck in high load app
Дата
Msg-id 42B99C20.1010905@commandprompt.com
обсуждение исходный текст
Ответ на Periodic bottle-neck in high load app  (KÖPFERL Robert <robert.koepferl@sonorys.at>)
Список pgsql-admin
> SO: Is there some periodic scheduled activity, postgres does lets say every
> 5 min ?  (that can pond up many many statements)
> What else could do that? Currently all periodic activities are paused.

Sounds like checkpoint.

http://www.postgresql.org/docs/8.0/interactive/sql-checkpoint.html

Sincerely,

Joshua D. Drake


>
>
> Tanks in advance
>
> PS. new harddisks are coming
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings


--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

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

Предыдущее
От: KÖPFERL Robert
Дата:
Сообщение: Periodic bottle-neck in high load app
Следующее
От: Francesco Dalla Ca'
Дата:
Сообщение: pg 8.0: Restoring the catalog after disk corruption: it's possible?