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@xxxxxxxxxxxxxxxxx] |Sent: Mittwoch, 22. Juni 2005 19:13 |To: KÖPFERL Robert |Cc: pgsql-admin@xxxxxxxxxxxxxx |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/ |
