Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Postgres 7.4.2 hanging when vacuum full is run
- From: Vivek Khera <vivek(at)khera(dot)org>
- To: Pgsql performance <pgsql-performance(at)postgresql(dot)org>
- Subject: Re: Postgres 7.4.2 hanging when vacuum full is run
- Date: Fri, 28 Sep 2007 10:53:20 -0400
On Sep 28, 2007, at 10:28 AM, Radhika S wrote: 20775 ? S 0:00 postgres: abc myDB [local] idle in transaction You're vacuum is probably waiting for the "idle in transaction" session to finish, so it can clean up. It can't take a lock if your transaction has locks. Your other tasks are probably waiting behind the vacuum. Don't leave your transactions open for a long time. it is bad. |
- References:
- Postgres 7.4.2 hanging when vacuum full is run
- From: Radhika S
- Postgres 7.4.2 hanging when vacuum full is run
- Prev by Date: Re: sequence query performance issues
- Next by Date: Re: Postgres 7.4.2 hanging when vacuum full is run
- Previous by thread: Postgres 7.4.2 hanging when vacuum full is run
- Next by thread: Re: Postgres 7.4.2 hanging when vacuum full is run
- Indexes: