Обсуждение: FATAL: 1 Memory exhausted in AllocSetAlloc()

Поиск
Список
Период
Сортировка

FATAL: 1 Memory exhausted in AllocSetAlloc()

От
"Igor N. Avtaev"
Дата:
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