From: Justin Pryzby <pryzby@telsasoft.com>
To: Jaime Casanova <jcasanov@systemguards.com.ec>
Cc: pgsql-hackers@postgresql.org, Alvaro Herrera <alvherre@alvh.no-ip.org>
Subject: Re: document that brin's autosummarize parameter is off by default
Date: Thu, 24 Feb 2022 13:35:20 -0600
Message-ID: <20220224193520.GY9008@telsasoft.com> (raw)
In-Reply-To: <20210406040254.GB2768@ahch-to>
References: <20210406040254.GB2768@ahch-to>
Ten months ago, Jaime Casanova wrote:
> Hi everyone,
>
> Just noted that the default value of autosummarize reloption for brin
> indexes is not documented, or at least not well documented.
>
> I added the default value in create_index.sgml where other options
> mention their own defaults, also made a little change in brin.sgml to
> make it more clear that is disabled by default (at least the way it
> was written made no sense for me, but it could be that my english is
> not that good).
It seems like "This last trigger" in the current text is intended to mean "The
second condition". Your change improves that.
Should we also consider enabling autosummarize by default ?
It was added in v10, after BRIN was added in v9.5. For us, brin wasn't usable
without autosummarize.
Also, note that vacuums are now triggered by insertions, since v13, so it might
be that autosummarize is needed much less.
--
Justin
PS. I hope there's a faster response to your pg_upgrade patch.
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: pryzby@telsasoft.com, jcasanov@systemguards.com.ec, alvherre@alvh.no-ip.org
Subject: Re: document that brin's autosummarize parameter is off by default
In-Reply-To: <20220224193520.GY9008@telsasoft.com>
* 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