[ADMIN] Periodic bottle-neck in high load app

2005-06-22 Thread KÖPFERL Robert
Hi, we're running a high load applicatoin (Disks are hard working). While the load is rather constant in it's short term behaviour, we are experiencing a bottle-neck in regular intervals. In such case all connections get used up and pgadmin's "server-status"-Window is totally filled with statemen

Re: [ADMIN] Periodic bottle-neck in high load app

2005-06-22 Thread Joshua D. Drake
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 Since