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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1kO6xK-0006EE-Rt
	for pgsql-hackers@arkaria.postgresql.org; Thu, 01 Oct 2020 22:21:43 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1kO6xJ-0003al-Oo
	for pgsql-hackers@arkaria.postgresql.org; Thu, 01 Oct 2020 22:21:41 +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 <alvherre@alvh.no-ip.org>)
	id 1kO6xI-0003aY-Q9
	for pgsql-hackers@lists.postgresql.org; Thu, 01 Oct 2020 22:21:41 +0000
Received: from wout3-smtp.messagingengine.com ([64.147.123.19])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <alvherre@alvh.no-ip.org>)
	id 1kO6xC-0001gI-7h
	for pgsql-hackers@postgresql.org; Thu, 01 Oct 2020 22:21:39 +0000
Received: from compute2.internal (compute2.nyi.internal [10.202.2.42])
	by mailout.west.internal (Postfix) with ESMTP id 7CA182D5;
	Thu,  1 Oct 2020 18:21:32 -0400 (EDT)
Received: from mailfrontend1 ([10.202.2.162])
  by compute2.internal (MEProxy); Thu, 01 Oct 2020 18:21:32 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:content-type:date:from:in-reply-to
	:message-id:mime-version:subject:to:x-me-proxy:x-me-proxy
	:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=eW5IHe4kpHw7dOm7d
	dSTgITNq0YmhYdupiv+VUQ3TmU=; b=Zs1N8IN7ej7UU8ejGCqoThSZxa5ycl5Cn
	UtZefcpX19Ml8vIdeextA6EpkCoKlHmEbMgSwTPFrhIEWyiV/cYT4OkCiFecjRgi
	sA4UxIoLaxaDBeYyMOchFm6/TSXsQLfIHesKBhrSV6cXQ77seFy8ne56D9L8ZVuG
	dzsjI09bw/fJnuFqVjc01qtS21WMVc54HFyiTdw4y31vt/s1NUL3K7hL6vwUKhrE
	bveQWQdTIEx+CGxiO+KiPsU1R32uu1bormb35wLZz4EXgMIk/wZl+ZDhqvB+ZFJZ
	7C+GsfYGXSB/gj0CtmITLETNZoJEhobUTRO/vw5yNPJMG1wt3cEeg==
X-ME-Sender: <xms:a1Z2X5TlKrOuAISgWkE_UKVPYdOthwhiw2pTjdLibSyOytNoqYcccQ>
    <xme:a1Z2XyzU7Bf9zGG3HoIC1VdT_RKQN2vd3AHB8PQdS5mOpdMhpVPKNYUPu28b_8XWX
    KEvFQBD3U5diLisVQ>
X-ME-Proxy-Cause: 
 gggruggvucftvghtrhhoucdtuddrgedujedrfeehgddthecutefuodetggdotefrodftvf
    curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu
    uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc
    fjughrpeffhffvuffkgggtuggjfgesthdtredttdervdenucfhrhhomheptehlvhgrrhho
    ucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgheqne
    cuggftrfgrthhtvghrnhepvefgleevgeeujeeghfegteeghfegheeifeehheelteetiedu
    ieeihffggfehffetnecukfhppeduledtrdelhedrudelrddugeeknecuvehluhhsthgvrh
    fuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhhvghrrhgvsegrlhhv
    hhdrnhhoqdhiphdrohhrgh
X-ME-Proxy: <xmx:a1Z2X-02Zq4gPWmxJzKPpuTVFPqnEo7m0p43jIIs16vJ8nRf6cuwwA>
    <xmx:a1Z2XxC9PYTiWw_D2n1Sj5MMJjhmCRxvbeUlilMkhos43EyytNhHGQ>
    <xmx:a1Z2XyikKS0TGMMX24mV_m2DOhlwkfgMd9Fk1BR_dokKAiLyOe7Rcw>
    <xmx:bFZ2X4fgbpvO1nxka1dqQUeNTCI7qkncsAN48TueooMOakpZxIzpnQ>
Received: from perhan.alvh.no-ip.org (unknown [190.95.19.148])
	by mail.messagingengine.com (Postfix) with ESMTPA id 403313280064;
	Thu,  1 Oct 2020 18:21:31 -0400 (EDT)
Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000)
	id AF06C2A1550; Thu,  1 Oct 2020 19:21:27 -0300 (-03)
Date: Thu, 1 Oct 2020 19:21:27 -0300
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: John Naylor <john.naylor@2ndquadrant.com>,
	pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: WIP: BRIN multi-range indexes
Message-ID: <20201001222127.GA24173@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20201001184133.oq5uq75sb45pu3aw@development>
User-Agent: Mutt/1.10.1 (2018-07-13)
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Precedence: bulk

On 2020-Oct-01, Tomas Vondra wrote:

> OK, so this seems like a data corruption bug in BRIN, actually.

Oh crap.  You're right -- the data needs to be detoasted before being
put in the index.

I'll have a look at how this can be fixed.