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 ???
|From: Joshua D. Drake [mailto:jd(at)commandprompt(dot)com]
|Sent: Mittwoch, 22. Juni 2005 19:13
|To: KÖPFERL Robert
|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
|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 - http://www.commandprompt.com/
pgsql-admin by date
|Next:||From: sandhya||Date: 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?|