FATAL: 1 Memory exhausted in AllocSetAlloc() - Mailing list pgsql-admin

From Igor N. Avtaev
Subject FATAL: 1 Memory exhausted in AllocSetAlloc()
Date
Msg-id 39FE83AC.B0BB621E@usi.ru
Whole thread Raw
List 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


pgsql-admin by date:

Previous
From: "Gavin M. Roy"
Date:
Subject: Cross DB Queries
Next
From: Jérome Knobl
Date:
Subject: How to recreate index of a pg table