Home > mailing lists

memory error - Mailing list pgsql-novice

From	Oeschey, Lars (I/EK-142, extern)
Subject	memory error
Date	October 17, 2007 14:46:08
Msg-id	17A09E9509BB354E95C2FEE5102B0F5F0131569F@audiinsx0036.audi.vwg Whole thread Raw
Responses	Re: memory error
List	pgsql-novice

Tree view

Hi,

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Â« fÃ¼r Tabelle Â»tbl_ecuÂ«
FEHLER:  Speicher aufgebraucht
DETAIL:  Fehler bei Anfrage mit GrÃ¶Ãe 268435456.

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

Postgresql is 8.1.9

Lars

pgsql-novice by date:

From: "Rodrigo De León"
Date: 17 October 2007, 14:19:56
Subject: Re: Implementation of a updateable, "temporal" view on data

From: Tom Lane
Date: 17 October 2007, 16:13:48
Subject: Re: memory error

memory error - Mailing list pgsql-novice

Previous

Next