Re: BUG #4339: The postgreSQL service stops abnormally

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