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