Jesper Krogh <jes...@krogh.cc> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
