Message-ID: <17c5b15451fac2ace7a815d1d2c8f86e1d232802.camel@cybertec.at>
Subject: Re: pg_attribute, pg_class, pg_depend grow huge in count and size
 with multiple tenants.
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Avinash Kumar <avinash.vallarapu@gmail.com>, Rory Campbell-Lange
	 <rory@campbell-lange.net>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>, samhitha g
	 <samhithagarudadri@gmail.com>, pgsql-performance@lists.postgresql.org
Date: Fri, 08 May 2020 08:31:14 +0200
In-Reply-To: 
 <CAN0TujfLZ22xm0u99B+jsB31R55fQ5OJ2PKgcmr0TZHUPwoTUw@mail.gmail.com>
References: 
	<CAG5FJBVFp4TtEde-xn2hpYQKByFxPQChXitrLorwyiN71+cPyA@mail.gmail.com>
	 <CAKFQuwafqFBr+jJ9fGie19CCDoBiGarJejhcwiYHaYyM+kY_kQ@mail.gmail.com>
	 <CAN0TujdCgR5TA4JW6T5Di6nL5RVShbUAfY+G-7Fc-ABH4U=--g@mail.gmail.com>
	 <20200507210846.GA17040@campbell-lange.net>
	 <CAN0TujfLZ22xm0u99B+jsB31R55fQ5OJ2PKgcmr0TZHUPwoTUw@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.32.5 (3.32.5-1.fc30) 
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Precedence: bulk

On Thu, 2020-05-07 at 18:17 -0300, Avinash Kumar wrote:
> > The nice thing about separate databases is that it is easy to scale
> > horizontally.
> 
> Agreed. But, how about autovacuum ? Workers shift from DB to DB and 500 clusters
> means you may have to have a lot of manual vacuuming in place as well.

Just set "autovacuum_max_workers" higher.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com