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?
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Andrew Sullivan
Sent: Monday, September 27, 2004 8:38 AM
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.
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.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
In response to
pgsql-general by date
|Next:||From: Esteban Kemp||Date: 2004-09-27 23:04:50|
|Subject: Aggregates ?? Datamart (to whatever it has implemented a DataMart using Postgres)|
|Previous:||From: David Helgason||Date: 2004-09-27 21:05:59|
|Subject: Re: Null comparisons (was Re: checksum)|