Re: [GENERAL] Deadlock between VACUUM and ALTER TABLE commands

2016-04-14 Thread Kevin Burke
e, with no other queries being generated during that time, could take 23 seconds to complete? The server is running Postgres 9.4.6. What other information do I/you need to figure out what's going on? Thanks, Kevin On Thu, Apr 7, 2016 at 1:26 AM, Alexey Bashtanov wrote: > Hello Kevin, &g

[GENERAL] Deadlock between VACUUM and ALTER TABLE commands

2016-04-06 Thread Kevin Burke
Hello, Occasionally our test suite gets into a deadlocked state. I was curious why this happens, and what our options are for dealing with it. We run ~2900 tests on an Ubuntu machine in sequence against a Postgres 9.4.6 database. There are about 60 tables; each test runs ~3 queries, and the larges