Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o6WSS-0001Ug-5d for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Jun 2022 12:06:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1o6WRS-0007A9-2n for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Jun 2022 12:05:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o6WRR-0007A0-N6 for pgsql-hackers@lists.postgresql.org; Wed, 29 Jun 2022 12:05:09 +0000 Received: from mail-qv1-xf2d.google.com ([2607:f8b0:4864:20::f2d]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1o6WRK-0006SK-0d for pgsql-hackers@lists.postgresql.org; Wed, 29 Jun 2022 12:05:08 +0000 Received: by mail-qv1-xf2d.google.com with SMTP id 2so9462396qvc.0 for ; Wed, 29 Jun 2022 05:05:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=+p2wrzD7XJwLoqBCgGBVdvm7+8OWkPRWreI1se/EbXc=; b=TPMDEsuma/Dg0oNRQjNfIqFQgVjCvZ7sGbuq8uPDLQ//FH8JmQKZvbDDXYmhamGRg5 P2FZA+SWu1IMjwH1dxLNPA6RFkEddIrSmUIruLWykrt/AXTwQLKSD8/RoWQnEGbIhPbc 44ZJOgxCpbsBEEO88FAFECcrrGVDcGt61nCh8y2g9dCZCgxczJhFba1jUwdsf+LS0WC0 gP9IRFvvziPo98Cvs96Mia6b6HUmQDNlsosQNWFv+xZcA7DQJZwTqKTVpnbGtsYAC6ka UdstBxqiQA6gB453RuI0BML18dGvvMOpBQKnYvrLobKH34SiejjB47RUoweEP0S0Uc5I Z7sg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=+p2wrzD7XJwLoqBCgGBVdvm7+8OWkPRWreI1se/EbXc=; b=y0orjYoAecdKG1GbmirDnwUP+wZyc24oLcE0bwna89qBe9cQVjIqtVr53wdfvhCLpl fE/FLYW0WKzAvkDlbEhCFnZvBdhHmngRtyyLtU6hvSLRUE7l689XBvsd4UnfuoHDduE5 oh6A8RpQue8hiGU/AbLAgTbzKvLM8TCKcFLxi3Y5kDrod8twtP3cb0ikqWPle6WNlE8I 7h21MPpkrsQWvpGN0QS2yk8so9rmiOX7b/sqNiP/E4E2fOW9hUkTYbB+b1jG2iNgRFae AsvIZkaRBTBDcf5hffXRnziSXYlReLeIMW97mEboy6Bpg0/M2XsI24/3KUJBFIHI30fv fqVA== X-Gm-Message-State: AJIora93/1rg6gw9voHdw1fKnC3HsVc1hWBjwaJ7xczMvannlkcJg3sr mOlA0HTADYlc5TK2tMNvZ9rgyw== X-Google-Smtp-Source: AGRyM1vZcuie4FHjrwUfSjmA0DgZlxatZ/R7zjwwV6HyZ4IbaIJ/9OhxD+iNc65GZT3WUNU5OLS9mQ== X-Received: by 2002:a05:622a:13d0:b0:31a:66b7:5143 with SMTP id p16-20020a05622a13d000b0031a66b75143mr2039852qtk.558.1656504299638; Wed, 29 Jun 2022 05:04:59 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id p20-20020ac84614000000b00304fe96c7aasm7444150qtn.24.2022.06.29.05.04.59 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 29 Jun 2022 05:04:59 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 4647B8006D0; Wed, 29 Jun 2022 07:04:58 -0500 (CDT) Date: Wed, 29 Jun 2022 07:04:58 -0500 From: Justin Pryzby To: Roberto Mello Cc: pgsql-hackers@lists.postgresql.org, Alvaro Herrera , Jaime Casanova Subject: Re: doc: BRIN indexes and autosummarize Message-ID: <20220629120458.GE28130@telsasoft.com> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Jun 28, 2022 at 05:22:34PM -0600, Roberto Mello wrote: > Here's a patch to clarify the BRIN indexes documentation, particularly with > regards to autosummarize, vacuum and autovacuum. It basically breaks down a > big blob of a paragraph into multiple paragraphs for clarity, plus explicitly > tells how summarization happens manually or automatically. See also this older thread https://www.postgresql.org/message-id/flat/20220224193520.GY9008@telsasoft.com -- Justin