Re: Out of memory on update of a single column table containg just one row.

From: Thomas Markus <t(dot)markus(at)proventis(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Out of memory on update of a single column table containg just one row.
Date: 2010-07-05 13:39:08
Message-ID: 4C31E07C.1080302@proventis.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

i tried a simple test:
create temp table _t as select repeat('x',382637520) as test;
update _t set test=test||test;

pg 8.3 32bit fails with
[Error Code: 0, SQL State: 53200] ERROR: out of memory
Detail: Failed on request of size 765275088.

pg 8.4.4 64bit works fine

so upgrade to 64bit

regards
Thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Zeeshan.Ghalib 2010-07-05 13:52:20 Re: Out of memory on update of a single column table containg just one row.
Previous Message Len Morgan 2010-07-05 13:33:11 Windows Installation Problem