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>
To:
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: ED4E30DD9C43D5118DFB00508BBBA76EB16793@neptun.sonorys.at (view raw or flat)
Thread:
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.
|
|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

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-2014 The PostgreSQL Global Development Group