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

Re: core dump on select

From: "John Liu" <johnl(at)stihealthcare(dot)com>
To: "'Andrew Sullivan'" <ajs(at)crankycanuck(dot)ca>,<pgsql-general(at)postgresql(dot)org>
Subject: Re: core dump on select
Date: 2004-09-27 21:18:41
Message-ID: 200409272118.i8RLIqRn032599@mail.stihealthcare.com (view raw or flat)
Thread:
Lists: pgsql-general
Core dump on select from psql on AIX 5.x

I have the following task at hand -
A huge table, one of the column data has duplicated entries. I want to find
those duplicated records in this column - 
select count(*), col-x from table-x group by col-x having count(*) >1; 

Of course, the above query will produce a core!! My question is: is there a
smart way in postgresql to solve this problem? Could I avoid this core dump
issue if I use pgplsql?

john
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Andrew Sullivan
Sent: Monday, September 27, 2004 8:38 AM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] core dump on select

On Fri, Sep 24, 2004 at 03:55:43PM -0500, John Liu wrote:
> max memory size (kbytes)    32768
> 
> open files                  2000
> 
> pipe size (512 bytes)       64
> 
> stack size (kbytes)         2097151

My guess is that one of these -- likely the first -- is biting you. 
What isn't clear to me is whether you're getting core from the
postmaster or psql itself.  I've seen the latter pretty frequently,
but there is a current segfault problem with AIX 5.1 at least.  

A

-- 
Andrew Sullivan  | ajs(at)crankycanuck(dot)ca
I remember when computers were frustrating because they *did* exactly what 
you told them to.  That actually seems sort of quaint now.
		--J.D. Baldwin

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org



In response to

Responses

pgsql-general by date

Next:From: Esteban KempDate: 2004-09-27 23:04:50
Subject: Aggregates ?? Datamart (to whatever it has implemented a DataMart using Postgres)
Previous:From: David HelgasonDate: 2004-09-27 21:05:59
Subject: Re: Null comparisons (was Re: checksum)

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