Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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)

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group