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
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 |