Re: PG connections going to 'waiting'

Alan McKay escribió:
> OK, looks like the time window is exactly when we run vacuum.   That
> has been running now for a couple of months no problem, but the last 2
> weekends we've been doing massive data loads which could be
> complicating things.
>
> Is vacuum a good candidate for what could be locking up the tables?

Vacuum full, which is what your script is using, locks tables.  But it's
not recommended.  You should be looking at an alternative vacuuming
strategy that does not involve vacuum full at all.  Perhaps autovacuum,
properly tuned, is a better solution.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support