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.