Re: Periodic bottle-neck in high load app - Mailing list pgsql-admin

From Joshua D. Drake
Subject Re: Periodic bottle-neck in high load app
Date
Msg-id 42B99C20.1010905@commandprompt.com
Whole thread Raw
In response to Periodic bottle-neck in high load app  (KÖPFERL Robert <robert.koepferl@sonorys.at>)
List 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 by date:

Previous
From: KÖPFERL Robert
Date:
Subject: Periodic bottle-neck in high load app
Next
From: Francesco Dalla Ca'
Date:
Subject: pg 8.0: Restoring the catalog after disk corruption: it's possible?