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

Hello Thom,

Thanks for your quick response.

So, is this there a restriction with 32-bit PostgreSQL, a bug or configuration issue?

I will most definitely upgrade to 64-bit, because that's what we want anyway. However, I was curious what is the root cause of this problem?

I am getting a bit worried about this migration, although our database is not too big (less than 200GB).

Once again, thanks for your help.

Zeeshan

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Thomas Markus
> Sent: 05 July 2010 14:39
> To: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Out of memory on update of a single column table
> containg just one row.
>
> 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
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
This e-mail is confidential and should not be used by anyone who is not the original intended recipient. Global DataPoint Limited does not accept liability for any statements made which are clearly the sender's own and not expressly made on behalf of Global DataPoint Limited. No contracts may be concluded on behalf of Global DataPoint Limited by means of e-mail communication. Global DataPoint Limited Registered in England and Wales with registered number 3739752 Registered Office Middlesex House, 34-42 Cleveland Street, London W1T 4LB