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/