Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: autovacuum ignore tables
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "Sriram Dandapani" <sdandapani(at)counterpane(dot)com>
- Cc: "Matthew T. O'Connor" <matthew(at)zeut(dot)net>, pgsql-admin(at)postgresql(dot)org
- Subject: Re: autovacuum ignore tables
- Date: Fri, 29 Sep 2006 14:10:06 -0400
"Sriram Dandapani" <sdandapani(at)counterpane(dot)com> writes: > I tried your code with the lock table followed by drop. > The lock table goes into a wait state AND all INSERTS (even new ones > coming in) go into a wait state. Well, it's waiting for something. Try looking in pg_locks to see which transaction is blocking it. regards, tom lane
- References:
- Re: autovacuum ignore tables
- From: Sriram Dandapani
- Re: autovacuum ignore tables
- Prev by Date: Re: autovacuum ignore tables
- Next by Date: Re: [JDBC] number of transactions doubling
- Previous by thread: Re: autovacuum ignore tables
- Next by thread: Re: autovacuum ignore tables
- Indexes: