Postgres Pro
Downloads
Home   >   mailing lists

Re: autovacuum ignore tables - Mailing list pgsql-admin

From Tom Lane
Subject Re: autovacuum ignore tables
Date
Msg-id 18335.1159553406@sss.pgh.pa.us
Whole thread Raw
In response to Re: autovacuum ignore tables  ("Sriram Dandapani" <sdandapani@counterpane.com>)
List pgsql-admin
Tree view 
"Sriram Dandapani" <sdandapani@counterpane.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

pgsql-admin by date:

Previous
From: "Sriram Dandapani"
Date:
Subject: Re: autovacuum ignore tables
Next
From: Jim Nasby
Date:
Subject: Re: [JDBC] number of transactions doubling