pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Rowley <dgrowleyml@gmail.com>
Cc: Dean Rasheed <dean.a.rasheed@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Andres Freund <andres@anarazel.de>
Cc: Alexander Korotkov <a.korotkov@postgrespro.ru>
Cc: Justin Pryzby <pryzby@telsasoft.com>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Cc: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: Amit Kapila <amit.kapila16@gmail.com>
Cc: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: Darafei Komяpa Praliaskouski <me@komzpa.net>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Cc: Michael Banck <mbanck@gmx.net>
Subject: Re: Berserk Autovacuum (let's save next Mandrill)
Date: Thu, 02 Apr 2020 19:44:34 -0400
Message-ID: <11572.1585871074@sss.pgh.pa.us> (raw)
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>

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 problem.
> I'm happy for you to go ahead on this.

Pushed, thanks for looking at it!

			regards, tom lane





view thread (158+ messages)

Message-ID: <11572.1585871074@sss.pgh.pa.us>
Permalink:  ../11572.1585871074@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/11572.1585871074@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: tgl@sss.pgh.pa.us, dgrowleyml@gmail.com, dean.a.rasheed@gmail.com, laurenz.albe@cybertec.at, andres@anarazel.de, a.korotkov@postgrespro.ru, pryzby@telsasoft.com, alvherre@2ndquadrant.com, masahiko.sawada@2ndquadrant.com, tomas.vondra@2ndquadrant.com, amit.kapila16@gmail.com, sawada.mshk@gmail.com, me@komzpa.net, pgsql-hackers@lists.postgresql.org, mbanck@gmx.net
  Subject: Re: Berserk Autovacuum (let's save next Mandrill)
  In-Reply-To: <11572.1585871074@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox