From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Rowley <dgrowleyml@gmail.com>
cc: Dean Rasheed <dean.a.rasheed@gmail.com>,
        Laurenz Albe <laurenz.albe@cybertec.at>,
        Andres Freund <andres@anarazel.de>,
        Alexander Korotkov <a.korotkov@postgrespro.ru>,
        Justin Pryzby <pryzby@telsasoft.com>,
        Alvaro Herrera <alvherre@2ndquadrant.com>,
        Masahiko Sawada <masahiko.sawada@2ndquadrant.com>,
        Tomas Vondra <tomas.vondra@2ndquadrant.com>,
        Amit Kapila <amit.kapila16@gmail.com>,
        Masahiko Sawada <sawada.mshk@gmail.com>,
        =?UTF-8?Q?Darafei_Kom=D1=8Fpa_Praliaskouski?= <me@komzpa.net>,
        PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>,
        Michael Banck <mbanck@gmx.net>
Subject: Re: Berserk Autovacuum (let's save next Mandrill)
In-reply-to: 
 <CAApHDvrEuNY75udRpxLLP-fzmEvRVQ6tEG=NqL5TxAghY-gPuQ@mail.gmail.com>
References: <20200325150656.GX21443@telsasoft.com>
 <20200325154652.GA13069@alvherre.pgsql>
 <20200325160521.GA21443@telsasoft.com>
 <20200325192641.cj3up5c5koqgyppb@alap3.anarazel.de>
 <CAPpHfdsuPoV0ray+bgQ7FP-Ycv9v7932Y09EXyMSjqB6zf+icg@mail.gmail.com>
 <64886d1e91cbf28dc696503cdbb9d6ef7fff94c4.camel@cybertec.at>
 <20200326185056.qncp7yefomq4qmzq@alap3.anarazel.de>
 <CAApHDvocmDm2_7nmu2JQeW2O_rjqDN3U-9SkiGNEpP99O+UcJQ@mail.gmail.com>
 <d31131bb126a7a91a68db668ed9b19e089de491e.camel@cybertec.at>
 <CAApHDvrp4DDODv475m3P-w-4uop6HEe9-moQOMXmR0hfCCsEvw@mail.gmail.com>
 <61d1ab62a22ee7976b8d099dda8c8089fae74a9f.camel@cybertec.at>
 <CAApHDvqseMeP406N=DmmMKb17ajJ39v1z+o3PKHTfB+9-BB26Q@mail.gmail.com>
 <CAApHDvpWmpqYrKwwDQyeDq8dAyK7GMNaxDhrG69CkSuXoEg+Vg@mail.gmail.com>
 <CAApHDvrOFj4i0=OVeNuwv8Gtsc6RhDLqz2=E=7mNsA1K5mKYAg@mail.gmail.com>
 <CAEZATCU0zHMDiQV0g8P2U+YSP9C1idUPrn79DajsbonwkN0xvQ@mail.gmail.com>
 <490.1585687710@sss.pgh.pa.us> <30041.1585689399@sss.pgh.pa.us>
 <22297.1585797192@sss.pgh!
 .pa.us> <CAApHDvrx1KGMdgn7q0JdqX8W3MgyEsF2F4O07WC0muscmScuTg@mail.gmail.com>
 <24467.1585838693@sss.pgh.pa.us> <17618.1585842396@sss.pgh.pa.us>
 <CAApHDvrEuNY75udRpxLLP-fzmEvRVQ6tEG=NqL5TxAghY-gPuQ@mail.gmail.com>
Comments: In-reply-to David Rowley <dgrowleyml@gmail.com>
	message dated "Fri, 03 Apr 2020 09:49:14 +1300"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <11571.1585871074.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Thu, 02 Apr 2020 19:44:34 -0400
Message-ID: <11572.1585871074@sss.pgh.pa.us>
Precedence: bulk

David Rowley <dgrowleyml@gmail.com> writes:
> On Fri, 3 Apr 2020 at 04:46, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Concretely, I suggest the attached, which replaces the autovac disables
>> with adjusting partition boundaries so that the partitions contain
>> different numbers of rows.

> I've looked over this and I agree that it's a better solution to the pro=
blem.
> I'm happy for you to go ahead on this.

Pushed, thanks for looking at it!

			regards, tom lane