Re: ERROR: Out of memory - when connecting to database - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: Out of memory - when connecting to database
Date
Msg-id 29618.1289248318@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: Out of memory - when connecting to database  (Jakub Ouhrabka <kuba@comgate.cz>)
Responses Re: ERROR: Out of memory - when connecting to database  (Jakub Ouhrabka <kuba@comgate.cz>)
List pgsql-general
Jakub Ouhrabka <kuba@comgate.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

pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: finding the other statement causing a sharelock
Next
From: Jakub Ouhrabka
Date:
Subject: Re: ERROR: Out of memory - when connecting to database