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
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
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