Re: [PERFORM] COMMIT stuck for days after bulk delete

On Tue, Jan 14, 2014 at 12:36 PM, Tom Lane wrote: > Josh Kupershmidt writes: >> We have a 9.1.11 backend (Ubuntu 12.04 x86_64, m1.medium EC2 instance) >> which seems to be stuck at COMMIT for 2 days now: >> ... >> The transaction behind that COMMIT has been the only thing running on >> this Postg

Re: [PERFORM] COMMIT stuck for days after bulk delete

Josh Kupershmidt writes: > We have a 9.1.11 backend (Ubuntu 12.04 x86_64, m1.medium EC2 instance) > which seems to be stuck at COMMIT for 2 days now: > ... > The transaction behind that COMMIT has been the only thing running on > this Postgres instance for the past 3 days or so, since Postgres was

[PERFORM] COMMIT stuck for days after bulk delete

We have a 9.1.11 backend (Ubuntu 12.04 x86_64, m1.medium EC2 instance) which seems to be stuck at COMMIT for 2 days now: mydb=# SELECT procpid, waiting, current_query, CURRENT_TIMESTAMP - query_start AS query_elapsed, CURRENT_TIMESTAMP - xact_start AS xact_elapsed FROM pg_stat_activity WHERE procp