Jesper Krogh <jesper@xxxxxxxx> writes: > What I seems to miss a way to make sure som "background" application is > the one getting the penalty, so a random user doing a single insert > won't get stuck. Is that doable? You could force a vacuum every so often, but I don't think that will help the locking situation. You really need to back off work_mem --- 512MB is probably not a sane global value for that anyway. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
