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
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 |