Thread: select query core dump
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
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.