Jakub Ouhrabka <k...@comgate.cz> writes:
>>> 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?
> Yes, there are two unique btree indexes:
> (col1, col2, col3, md5(array_to_string(col_bytea_arr, ''::text)) where
> col4 is not null
> (col1, col2, col3, md5(array_to_string(col_bytea_arr, ''::text)) where
> col4 is null
> What is the cause of the out of memory then?
Hmm. I suspect that evaluation of that md5() call is resulting in
memory leakage, but not sure why or where exactly.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
