Re: ERROR: Out of memory - when connecting to database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jakub Ouhrabka <kuba(at)comgate(dot)cz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: Out of memory - when connecting to database
Date: 2010-11-08 20:31:58
Message-ID: 29618.1289248318@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jakub Ouhrabka <kuba(at)comgate(dot)cz> writes:
> Could it be that the failed connections were issued by autovacuum?

They clearly were: notice the reference to "Autovacuum context" in the
memory map. I think you are right to suspect that auto-analyze was
getting blown out by the wide bytea columns. Did you have any
expression indexes involving those columns?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2010-11-08 20:37:50 Removing pgsql_tmp files
Previous Message Ivan Sergio Borgonovo 2010-11-08 19:52:15 finding the other statement causing a sharelock