On Fri, Oct 25, 2019 at 10:23 AM rihad <rihad@xxxxxxx> wrote: > LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp92452.1079", size 166518 > STATEMENT: DELETE FROM "foo" WHERE ((col1, col2, col3) in (select col1, > col2, col3 from foo_xml_v2('<here goes xml-formatted blob>'))) AND > "foo"."col_id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9) Isn't work_mem used for hashing and sorting, gin and stuff like that? Luca