Skip site navigation (1) Skip section navigation (2)

Re: select query core dump

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: John Liu <johnl(at)stihealthcare(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: select query core dump
Date: 2004-09-27 09:31:48
Message-ID: 20040927093145.GE23773@svana.org (view raw or flat)
Thread:
Lists: pgsql-general
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(at)svana(dot)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.

In response to

pgsql-general by date

Next:From: Philippe LangDate: 2004-09-27 09:43:42
Subject: How to terminate an individual client connection gracefully?
Previous:From: Dennis GearonDate: 2004-09-27 08:33:22
Subject: Re: IN or JOIN

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group