John R Pierce <pierce@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
