Hi, Bhaskar Sirohi wrote: > ...
2008-07-30 15:05:01 EDT LOG: checkpoints are occurring too frequently (28 seconds apart) 2008-07-30 15:05:01 EDT HINT: Consider increasing the configuration parameter "checkpoint_segments". 2008-07-30 15:13:34 EDT LOG: checkpoints are occurring too frequently (29 seconds apart) 2008-07-30 15:13:34 EDT HINT: Consider increasing the configuration parameter "checkpoint_segments". 2008-07-30 15:18:50 EDT LOG: checkpoints are occurring too frequently (28 seconds apart) 2008-07-30 15:18:50 EDT HINT: Consider increasing the configuration parameter "checkpoint_segments". 2008-07-30 15:19:21 EDT LOG: received fast shutdown request
These log lines look like your database is touching lots of tuples, requiring it to checkpoint frequently. Then it receives a fast shutdown request - from whoever.
What causes the workload? Did you check memory usage? (And uh.. does Windows 2003 Server have an OOM Killer or some such?)
Regards Markus Wanner -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
