Re: BUG #2113: PostgreSQL hangs after running for 2 days - Mailing list pgsql-bugs

From Qingqing Zhou
Subject Re: BUG #2113: PostgreSQL hangs after running for 2 days
Date
Msg-id dnqqhu$2dtm$1@news.hub.org
Whole thread Raw
In response to BUG #2113: PostgreSQL hangs after running for 2 days  ("Wojciech Sobczuk" <wojtek@brandlay.com>)
List pgsql-bugs
""Wojciech Sobczuk"" <wojtek@brandlay.com> wrote
>
> I have a 16GB database which is very busy (100 requests per second).
> After
> running for some time (sometimes 2 days sometimes longer sometimes
> shorter)
> postgres hangs.

Can you follow the steps in this thread to find out what's going on of the
hanged process (but for sure there is no such problem in 8.x):

http://archives.postgresql.org/pgsql-hackers/2005-10/msg00459.php

Regards,
Qingqing

pgsql-bugs by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: BUG #2115: If we CLOSE a Closed Cursor subsequent OPENs fail.
Next
From: Tom Lane
Date:
Subject: Re: BUG #2113: PostgreSQL hangs after running for 2 days