Re: PostgreSQL 9.0.4 crashing - Mailing list pgsql-general

From John R Pierce
Subject Re: PostgreSQL 9.0.4 crashing
Date
Msg-id 4FC7E844.2010808@hogranch.com
Whole thread Raw
In response to PostgreSQL 9.0.4 crashing  ("R, Abhilash (HP Software)" <abhilash.r@hp.com>)
List 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 by date:

Previous
From: Jeff Davis
Date:
Subject: Re: pg_upgrade from 9.0.7 to 9.1.3: duplicate key pg_authid_oid_index
Next
From: Lonni J Friedman
Date:
Subject: autovacuum running for a long time on a new table with 1 row