Re: Periodic bottle-neck in high load app

> 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/