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

From Bhaskar Sirohi
Subject Re: BUG #4339: The postgreSQL service stops abnormally
Date
Msg-id 6ac0e4040808060449u2f3132aaib58080bbe6b2bb80@mail.gmail.com
Whole thread Raw
In response to Re: BUG #4339: The postgreSQL service stops abnormally  (Markus Wanner <markus@bluegap.ch>)
Responses Re: BUG #4339: The postgreSQL service stops abnormally
List pgsql-bugs
Hello Markus,

Thanks for the reply.

For the past one week postgreSQL service has been running absolutely fine
-:)

Also there is no OOM killer application on the windows 2003 server. I
haven't made any changes on the machine since first the service failed.

Nothing in the event logs also.

Can there be any another reason why the service failed ?

 --
Thanks and Regards

Bhaskar Sirohi
bhaskar.sirohi@druvaa.com
www.druvaa.com
(C) +91 986 094 6619


On Tue, Aug 5, 2008 at 5:50 PM, Markus Wanner <markus@bluegap.ch> wrote:

> 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: Simon Riggs
Date:
Subject: Re: Hmm, nodeUnique doesn't really support backwards scan too well
Next
From: Markus Wanner
Date:
Subject: Re: BUG #4339: The postgreSQL service stops abnormally