Re: core dump - Mailing list pgsql-general

From Scott Marlowe
Subject Re: core dump
Date
Msg-id 1086647469.27200.21.camel@localhost.localdomain
Whole thread Raw
In response to core dump  ("John Liu" <johnl@emrx.com>)
Responses Re: core dump
List pgsql-general
On Mon, 2004-06-07 at 15:57, John Liu wrote:
> We upgraded from 7.2 to 7.4, it looks like everything working, but
> when I issue a query such as select * from tab (tab has about 2-3
> million records), it causes core dump. I tuned some the parameters, it
> still produce the core.

How odd.  Anything else cause it to dump quickly?

Does it core if you just run explain select ... (note the lack of an
analyze there, as we don't want anything but the planner to run.)

Does selecting from another large table cause the same problem, or is
this a one table thing?


pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: generic insert into table
Next
From: "Scott Marlowe"
Date:
Subject: Re: core dump