Skip site navigation (1) Skip section navigation (2)

Re: Periodic bottle-neck in high load app

From: 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-23 13:04:29
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Yeah, that was it,  thank you.

However this doesn't solve our problem.
I've already set checkpoints to occour every 1 wal file. This seems to be
slightly better, but the overhead is also increased.
What's usually better ? checkpoint more often or more seldom, even 1/day ???

|-----Original Message-----
|From: Joshua D. Drake [mailto:jd(at)commandprompt(dot)com]
|Sent: Mittwoch, 22. Juni 2005 19:13
|To: KÖPFERL Robert
|Cc: pgsql-admin(at)postgresql(dot)org
|Subject: Re: [ADMIN] 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.
|Joshua D. Drake
|> Tanks in advance 
|> PS. new harddisks are coming
|> ---------------------------(end of 
|> 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 -

pgsql-admin by date

Next:From: sandhyaDate: 2005-06-23 13:12:13
Subject: reg:libpqxx on windows
Previous:From: Francesco Dalla Ca'Date: 2005-06-23 08:11:16
Subject: pg 8.0: Restoring the catalog after disk corruption: it's possible?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group