Re: pg_autovacuum taking locks on multiple tables at the same time - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_autovacuum taking locks on multiple tables at the same time
Date
Msg-id 9645.1160433393@sss.pgh.pa.us
Whole thread Raw
In response to pg_autovacuum taking locks on multiple tables at the same time  (Hari Bhaskaran <hbhaskaran@gmail.com>)
List pgsql-general
Hari Bhaskaran <hbhaskaran@gmail.com> writes:
> Why does pg_autovacuum need locks on more than one table at a time?

It doesn't --- unless maybe you are considering system catalogs, in
which case I'd wonder why you need exclusive lock on a catalog.

If you can prove the contrary, let's see a test case.

            regards, tom lane

pgsql-general by date:

Previous
From: "pobox@verysmall.org"
Date:
Subject: Re: plpgsql handling a set of values
Next
From: "Alex Turner"
Date:
Subject: Size of tuples