| 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: | Whole Thread | Raw Message | 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 |