Re: unexpected lock waits (was Re: [GENERAL] Do not understand why this happens)

commit does have a bit of impact, but the bulk of the time is elsehwere. [1]: https://www.postgresql.org/message-id/cadwg95t0j9zf0uwdcmh81kmndsitavhxmbvgyqrrjcd-ilw...@mail.gmail.com [2]: https://www.postgresql.org/message-id/cadwg95ulhar1uq6pqloy1mtqyen23c1dvor2tvjcxubz1ge...@mail.gmail.com Ho

Issue with COMMITs stuck on "AccessExclusiveLock on object 0 of class 1262 of database 0"

C [33900-2] [th.t6] app_t6@app_t6 DETAIL: Process holding the lock: 33162. Wait queue: 33226, 32565, 32443, 32452, 33923, 33900, 31701, 33827, 33844, 33427, 33359, 34012, 34005, 32054, 26820, 32788, 33587, 34062, 32282, 34127, 34129, 34080, 33161. 2019-03-27 01:40:43 UTC [33900-3] [th.t6] app_t6@app_t6 STATEMENT: COMMIT -- Martijn van Oosterhout http://svana.org/kleptog/