From: | "Bhaskar Sirohi" <bhaskar(dot)sirohi(at)druvaa(dot)com> |
---|---|
To: | "Markus Wanner" <markus(at)bluegap(dot)ch> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #4339: The postgreSQL service stops abnormally |
Date: | 2008-08-06 11:49:08 |
Message-ID: | 6ac0e4040808060449u2f3132aaib58080bbe6b2bb80@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)sirohi(at)druvaa(dot)com
www.druvaa.com
(C) +91 986 094 6619
On Tue, Aug 5, 2008 at 5:50 PM, Markus Wanner <markus(at)bluegap(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Wanner | 2008-08-06 12:13:30 | Re: BUG #4339: The postgreSQL service stops abnormally |
Previous Message | Simon Riggs | 2008-08-06 04:14:09 | Re: Hmm, nodeUnique doesn't really support backwards scan too well |