FATAL: 1 Memory exhausted in AllocSetAlloc()

From: "Igor N(dot) Avtaev" <ain(at)usi(dot)ru>
To: pgsql-admin(at)postgresql(dot)org
Subject: FATAL: 1 Memory exhausted in AllocSetAlloc()
Date: 2000-10-31 08:32:44
Message-ID: 39FE83AC.B0BB621E@usi.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello all! Help me please!

I'm having the table "mytable":
CREATE TABLE mytable (
a1 char(6) not null,
a2 char(1) not null,
a3 char(15) not null,
S1 char(8) not null,
S2 char(6) not null,
a4 integer not null,
a5 integer not null
);

I'm having a trouble with follow SQL-query:

SELECT min(S1 || S2), max(S1 || S2) FROM mytable;

If the table in question is the not large in the database -- about 120
000 rows
then execution OK.

If the table in question -- about 160 000 rows
then not execution.
Postmaster output to stderr:
FATAL: 1 Memory exhausted in AllocSetAlloc()

Please, tell me - what can I do?!
------------------------------------------------------------------------------

DBMS: PostgreSQL 7.0.2
OS: SCO UnixWare 2.1.3
Machine: HP Netserver E30, Pentium 166, 128Mb RAM, 4Gb and 9Gb Wide-SCSI
HDD

Best regards,
Igor Avtaev

Browse pgsql-admin by date

  From Date Subject
Next Message Jérome Knobl 2000-11-01 08:54:51 How to recreate index of a pg table
Previous Message Gavin M. Roy 2000-10-30 19:17:03 Cross DB Queries