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