Jakub Ouhrabka <kuba@xxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
