Skip site navigation (1) Skip section navigation (2)

Re: BUG #2113: PostgreSQL hangs after running for 2 days

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2113: PostgreSQL hangs after running for 2 days
Date: 2005-12-15 04:14:49
Message-ID: dnqqhu$2dtm$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
""Wojciech Sobczuk"" <wojtek(at)brandlay(dot)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








In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-12-15 06:25:55
Subject: Re: BUG #2113: PostgreSQL hangs after running for 2 days
Previous:From: Michael FuhrDate: 2005-12-15 03:22:53
Subject: Re: BUG #2115: If we CLOSE a Closed Cursor subsequent OPENs fail.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group