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

Re: 8.3rc1 Out of memory when performing update

From: "Roberts, Jon" <Jon(dot)Roberts(at)asurion(dot)com>
To: <cgallant(at)gmail(dot)com>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: 8.3rc1 Out of memory when performing update
Date: 2008-01-25 18:36:28
Message-ID: 1A6E6D554222284AB25ABE3229A927627154CE@nrtexcus702.int.asurion.com (view raw or flat)
Thread:
Lists: pgsql-performance
> Subject: Re: [PERFORM] 8.3rc1 Out of memory when performing update
> 
> >
> > > A simple update query, over roughly 17 million rows, populating a
> > > newly added column in a table, resulted in an out of memory error
> > > when the process memory usage reached 2GB. Could this be due to a
> > > poor choice of some configuration parameter, or is there a limit
on
> > > how many rows I can update in a single statement?
> > >
> >
> >    I believe that it is plataform problem. Because on *nix this
limit
> > don't occur. But I don't specialist Windows.
> 
> On most Windows Servers(except for database edition and a few other
> variants), 2Gb is the most you can address to a single
> process without booting the machine with a special parameter called
\3G
> which will allow for allocating up to 3Gb per process.  That is the
> limit unless you get special versions of windows server 2003 as far as
I
> know.  If you do a google search on \3G with windows you will find
what
> I am refering too.

Windows 32 bit is limited to 2 or 3 GB as you state but 64 bit Windows
isn't.  32 bit Linux has similar limits too.


Jon

In response to

Responses

pgsql-performance by date

Next:From: Magnus HaganderDate: 2008-01-25 18:45:43
Subject: Re: 8.3rc1 Out of memory when performing update
Previous:From: cgallantDate: 2008-01-25 18:32:46
Subject: Re: 8.3rc1 Out of memory when performing update

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