Re: Periodic bottle-neck in high load app

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Periodic bottle-neck in high load app
Date: 2005-06-22 17:13:04
Message-ID: 42B99C20.1010905@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Paul Keyes 2005-06-22 20:02:24 moving database to diff. server
Previous Message KÖPFERL Robert 2005-06-22 16:57:48 Periodic bottle-neck in high load app