Re: select query core dump - Mailing list pgsql-general

From Gaetano Mendola
Subject Re: select query core dump
Date
Msg-id 415739B8.8050800@bigfoot.com
Whole thread Raw
In response to select query core dump  ("John Liu" <johnl@stihealthcare.com>)
List pgsql-general
John Liu wrote:
> Pg version 7.4 on AIX,
>
>   psql dbs
>
>> >select * from tablex;
>
>  core dump, tablex has about 5 million records. What’s the proper
> approach to debug it?

A good start point is to upgrade to last version of the 7.4 series,
the 7.4.5 ( at time of this reply ).
If the application still do a core dump could be usefull analyze
the core and extract the stack trace ( I don't know if the gdb exist on AIX ).





Regards
Gaetano Mendola





pgsql-general by date:

Previous
From: gearond@fireserve.net
Date:
Subject: Re: wierd reserved word?
Next
From: Tom Lane
Date:
Subject: Re: Large arrays give long lag on server side before command executes