Re: BUG #4339: The postgreSQL service stops abnormally - Mailing list pgsql-bugs

From Markus Wanner
Subject Re: BUG #4339: The postgreSQL service stops abnormally
Date
Msg-id 489845A9.4090308@bluegap.ch
Whole thread Raw
In response to BUG #4339: The postgreSQL service stops abnormally  ("Bhaskar Sirohi" <bhaskar.sirohi@druvaa.com>)
Responses Re: BUG #4339: The postgreSQL service stops abnormally
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #4340: SECURITY: Is SSL Doing Anything?
Next
From: Magnus Hagander
Date:
Subject: Re: BUG #4186: set lc_messages does not work