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

Re: 8.3rc1 Out of memory when performing update

From: Fernando Ike <fike(at)midstorm(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: 8.3rc1 Out of memory when performing update
Date: 2008-01-25 01:14:33
Message-ID: 20080124231433.2f312549@pmanson (view raw or flat)
Thread:
Lists: pgsql-performance
Em Fri, 25 Jan 2008 12:46:20 +1300
"Stephen Denne" <Stephen(dot)Denne(at)datamail(dot)co(dot)nz> escreveu:

> 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.



Kind Regards,
-- 
Fernando Ike
http://www.midstorm.org/~fike/weblog

In response to

Responses

pgsql-performance by date

Next:From: Fernando IkeDate: 2008-01-25 01:53:52
Subject: Re: Configuration settings (shared_buffers, etc) in Linux: puzzled
Previous:From: Stephen DenneDate: 2008-01-24 23:46:20
Subject: 8.3rc1 Out of memory when performing update

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