Re: 8.3rc1 Out of memory when performing update

Поиск
Список
Период
Сортировка
От Fernando Ike
Тема Re: 8.3rc1 Out of memory when performing update
Дата
Msg-id 20080124231433.2f312549@pmanson
обсуждение исходный текст
Ответ на 8.3rc1 Out of memory when performing update  ("Stephen Denne" <Stephen.Denne@datamail.co.nz>)
Ответы Re: 8.3rc1 Out of memory when performing update  (cgallant@gmail.com)
Список pgsql-performance
Em Fri, 25 Jan 2008 12:46:20 +1300
"Stephen Denne" <Stephen.Denne@datamail.co.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

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

Предыдущее
От: "Stephen Denne"
Дата:
Сообщение: 8.3rc1 Out of memory when performing update
Следующее
От: Fernando Ike
Дата:
Сообщение: Re: Configuration settings (shared_buffers, etc) in Linux: puzzled