Seref Arikan <serefarikan@xxxxxxxxxxxxxxxxxxxxx> writes: > What may be building up here? I suspect deleting all rows from the temp > tables is not really deleting them since this is all happening in a > transaction, but it is my uneducated guess only. I suspect you suspect correctly. Autovacuum does not touch temp tables, so it won't help you deal with deleted tuples. Given the usage pattern you're describing, I think that using a TRUNCATE rather than delete-all-the-rows would help ... but if you're already doing that, we need more info. regards, tom lane
