Re: Autovacuum in the backend - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Autovacuum in the backend
Date
Msg-id 20092.1119016492@sss.pgh.pa.us
Whole thread Raw
In response to Re: Autovacuum in the backend  ("Matthew T. O'Connor" <matthew@zeut.net>)
List pgsql-hackers
"Matthew T. O'Connor" <matthew@zeut.net> writes:
> ...  People just didn't like including libpq 
> into the backend for reasons I don't remember.

One reason I can think of is that there would be global-symbol conflicts
--- libpq has copies of some backend routines, but they are not
identical.

In any case, the argument that's being made here is that an integrated
autovac would be simple and newbie-friendly.  I think it's impossible
for a libpq-using autovac to ever be invisible to the DBA, if only
because he has to configure it with an appropriate username/password,
make sure pg_hba.conf will actually let it into every database, etc.
There are way too many foot-guns in that scenario for my taste.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Autovacuum in the backend
Next
From: Tom Lane
Date:
Subject: Re: Utility database (Was: RE: Autovacuum in the backend)