Re: 8.3rc1 Out of memory when performing update

Поиск
Список
Период
Сортировка
От cgallant@gmail.com
Тема Re: 8.3rc1 Out of memory when performing update
Дата
Msg-id 20080125183246.GB32623@soleauthority.ca
обсуждение исходный текст
Ответ на Re: 8.3rc1 Out of memory when performing update  (Fernando Ike <fike@midstorm.org>)
Ответы Re: 8.3rc1 Out of memory when performing update  ("Roberts, Jon" <Jon.Roberts@asurion.com>)
Список pgsql-performance
>
> > 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.

Hope that helps a bit.

Cheers,

---
Curtis Gallant
cgallant@gmail.com

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Tory M Blue"
Дата:
Сообщение: Re: Postgres 8.2 memory weirdness
Следующее
От: "Roberts, Jon"
Дата:
Сообщение: Re: 8.3rc1 Out of memory when performing update