Re: PostgreSQL 9.0.4 crashing

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL 9.0.4 crashing
Date: 2012-05-31 21:53:08
Message-ID: 4FC7E844.2010808@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Trevor Campbell 2012-05-31 22:29:47 Trouble with plan statistics for behaviour for query.
Previous Message Jeff Davis 2012-05-31 21:28:54 Re: pg_upgrade from 9.0.7 to 9.1.3: duplicate key pg_authid_oid_index