Re: PostgreSQL 9.0.4 crashing

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: PostgreSQL 9.0.4 crashing
Дата
Msg-id 4FC7E844.2010808@hogranch.com
обсуждение исходный текст
Ответ на PostgreSQL 9.0.4 crashing  ("R, Abhilash (HP Software)" <abhilash.r@hp.com>)
Список pgsql-general
On 05/31/12 2:57 AM, R, Abhilash (HP Software) wrote:
> 2012-05-31 03:15:54 IST LOG:  server process (PID 49972) was
> terminated by exception 0xC000012D

Out of virtual memory

Error exception 0xC000012D
   Your system is low on virtual memory. To ensure that Windows runs
correctly,
   increase the size of your virtual memory paging file.
   For more information, see Help.


thats the description of that fault code from MS Windows.    so,
something you did in server process 49972 ate up more memory than was
available.    a query that returns a huge result set can do this as the
result set has to be collected in memory before it can be returned to
the client.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


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

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: pg_upgrade from 9.0.7 to 9.1.3: duplicate key pg_authid_oid_index
Следующее
От: Lonni J Friedman
Дата:
Сообщение: autovacuum running for a long time on a new table with 1 row