"Wojciech Sobczuk" <[EMAIL PROTECTED]> writes:
> 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. Last time it happened I got the following error in the
> log:
> ERROR:
""Wojciech Sobczuk"" <[EMAIL PROTECTED]> 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 o
On Wed, Dec 14, 2005 at 06:16:19PM +, David S. Edwards wrote:
> We are evaluating Postgres for a very large customer who has a lot of legacy
> software that they have executed with several proprietary RDBMS. We have run
> into a situation that is common in their batch code. They OPEN a cursor
>
The following bug has been logged online:
Bug reference: 2115
Logged by: David S. Edwards
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.0
Operating system: Red Hat Enterprise Linux AS release 4 Kernel 2.6.9-22
Description:If we CLOSE a Closed Cursor subsequ
The following bug has been logged online:
Bug reference: 2114
Logged by: Ben Gould
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.0
Operating system: Mac OS X 10.4.3
Description:(patch) COPY FROM ... end of copy marker corrupt
Details:
With a table like:
The following bug has been logged online:
Bug reference: 2113
Logged by: Wojciech Sobczuk
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: FreeBSD 5.4-RELEASE-p1
Description:PostgreSQL hangs after running for 2 days
Details:
I have a 16GB
"Jim Dew" <[EMAIL PROTECTED]> writes:
> Stumbled upon a (broken) query that causes the 8.1.0 thread handling the
> query to die:
> select foo from (select null) as foo
Fixed in 8.0 and up. If you need the patch for 8.1, it's pretty simple:
Index: src/backend/executor/execQual.c
=
