Re: [PERFORM] Problem with ExclusiveLock on inserts

2014-02-25 Thread Бородин Владимир
With these settings auto vacuuming of all tables became more often (as was expected), but not of big tables with lots of inserts (and with absolutely no updates). I've done a cron-script that does "vacuum analyze" for all databases which runs every hour. And it seems that right now I don't have

Re: [PERFORM] Planner performance extremely affected by an hanging transaction (20-30 times)?

2014-02-25 Thread Josh Berkus
On 02/25/2014 08:06 AM, Tom Lane wrote: > Well, it's three months later, and none of the people who were complaining > so vociferously in this thread seem to have bothered to test the proposed > solution. Sorry about that. The client lost interest once they had a workaround (fixing the hanging tr

Re: [PERFORM] Planner performance extremely affected by an hanging transaction (20-30 times)?

2014-02-25 Thread Tom Lane
I wrote: > Andres Freund writes: >> Also, this really isn't going to fix the issue discussed here - this was >> just about the additional ProcArrayLock contention. I don't think it >> would change anything dramatical in your case. > All of these proposals are pretty scary for back-patching purpos