Re: [BUGS] 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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs