Re: memory error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Oeschey, Lars (I/EK-142, extern)" <extern(dot)Lars(dot)Oeschey(at)AUDI(dot)DE>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: memory error
Date: 2007-10-17 16:13:39
Message-ID: 7082.1192637619@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Oeschey, Lars (I/EK-142, extern)" <extern(dot)Lars(dot)Oeschey(at)AUDI(dot)DE> writes:
> I have a table with 46 million rows, when I execute the following statement on it, I get an error:

> ALTER TABLE ONLY etefas.tbl_ecu ADD CONSTRAINT pk_tbl_ecu PRIMARY KEY (pk_ecu);
> HINWEIS: ALTER TABLE / ADD PRIMARY KEY erstellt implizit einen Index pk_tbl_ecu fr Tabelle tbl_ecu
> FEHLER: Speicher aufgebraucht
> DETAIL: Fehler bei Anfrage mit Gre 268435456.

> The statement came not from my head, but from a dump of the database (hence, the restore fails there, too). Am I doing something wrong?

What have you got maintenance_work_mem set to?

regards, tom lane

In response to

  • memory error at 2007-10-17 14:45:59 from Oeschey, Lars (I/EK-142, extern)

Browse pgsql-novice by date

  From Date Subject
Next Message Nikolai Cheltsov 2007-10-18 09:34:29 manage connections
Previous Message Oeschey, Lars (I/EK-142, extern) 2007-10-17 14:45:59 memory error