John R Pierce <pie...@hogranch.com> writes:
> On 10/29/2015 11:52 AM, Jim Longwill wrote:
>> I would like to do a different vacuum configuration on ddev2 than on
>> ddev1, such as turning off autovacuum, etc. How do I do this? E.g.
>> how do I turn off autovacuum on one database .. using different
>> postgres.conf files(?) or within the database, without affecting the
>> other database(s) on the same localhost?
>> Is there a relatively easy way to do this?
> alter database dbname set autovacuum = false;
Might be trickier than it looks though. I think individual autovacuum
worker processes will pick up such settings, but the launcher will not
since it doesn't ever attach to any individual database. So a lot of
undocumented implementation details would matter as to where particular
settings get used ...
Might be better to settle for configuring specific large tables using
per-table vacuum settings, and not sweat the small stuff at a per-DB
level.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
