Hello Guys,
We are trying to migrate from Oracle to Postgres. One of the major requirement
of our database is the ability to generate XML feeds and some of our XML files
are in the order of 500MB+.
We are getting "Out of Memory" errors when doing an update on a table.
Here is some detai
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Sam Mason
> Sent: 05 July 2010 15:14
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Out of memory on update of a single column table
> containg jus
On Mon, Jul 05, 2010 at 01:52:20PM +, zeeshan.gha...@globaldatapoint.com
wrote:
> So, is this there a restriction with 32-bit PostgreSQL, a bug or
> configuration issue?
It's a restriction because of the 32bit address space. You've basically
got between two and three GB of useful space left
ent: 05 July 2010 14:39
> To: pgsql-general@postgresql.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;
> upda
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
> -Original Message-
> From: Thom Brown [mailto:thombr...@gmail.com]
> Sent: 05 July 2010 12:40
> To: Zeeshan Ghalib
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Out of memory on update of a single column table
> containg just one row.
> Hi Zeesh
On 5 July 2010 11:47, wrote:
> Hello Guys,
>
>
>
> We are trying to migrate from Oracle to Postgres. One of the major
> requirement of our database is the ability to generate XML feeds and some of
> our XML files are in the order of 500MB+.
>
>
>
> We are getting "Out of Memory" errors when doin
Hello Guys,
We are trying to migrate from Oracle to Postgres. One of the major requirement
of our database is the ability to generate XML feeds and some of our XML files
are in the order of 500MB+.
We are getting "Out of Memory" errors when doing an update on a table.
Here is some detai
