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