Обсуждение: select query core dump

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

What you are doing there is loading the entire table into memory so you
can browse it. You're probably running out of memory.

Limit the query somehow or just add "LIMIT 1000" to only show the first
1000 rows.

On Mon, Sep 20, 2004 at 04:22:34PM -0500, 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?
>
>
>
> Thanks.
>
> johnl
>

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.