Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hqM4c-00058j-Cx for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Jul 2019 18:33:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hqM4b-0000jG-1K for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Jul 2019 18:33:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hqM4a-0000j9-Og for pgsql-hackers@lists.postgresql.org; Wed, 24 Jul 2019 18:33:08 +0000 Received: from mail-lj1-f196.google.com ([209.85.208.196]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hqM4U-0004uL-E2 for pgsql-hackers@postgresql.org; Wed, 24 Jul 2019 18:33:08 +0000 Received: by mail-lj1-f196.google.com with SMTP id x25so45518335ljh.2 for ; Wed, 24 Jul 2019 11:33:01 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=H2OM+Bh32Qm2XuNS8vTGABlG64lGFsQtvC9Bda8vYq8=; b=UQUxLv4QOGZ2l6oVmW/QqxX+w13Hp5b7Q8yNfKGlVDRlRxC0YvsMSsaVOKRZKs+9SN h9jI43Txb6XjFpV4/1Y23WtYwoG2hfC+LuGW4s/lJSfQyX2XYgkNX5e6FwN1PFG2a1gw buDtl9p/SMhpDiuHnZUYNIDxOM8wRCLZlBydjy2249knLsbkyDREIaFCHxtFUHifinFt 1DUT/gpDEXxu/V+rehqXt/0Mjbu3y/Ef59EcPcl2GJtWOnCO4vZHkiRkiEOyIhzx7zYH vYsOXMJaml+5gcdQ4V83z9cIpdlYmHorS6+IsKu6iLoJUQf1Cama3Dg15Q7qk665PRjV hCwA== X-Gm-Message-State: APjAAAWO3uU8JdARp+O3/fBU/NYh+VdNz3M7qUrP1X4zFWVVitOxHmTC 588uydViF8rPOaOEfBtNanQ= X-Google-Smtp-Source: APXvYqw2xD/CUErfo/vAG2PUSpulOmJNXWgAx+b/EhQN5jvAmWhYBXKkhlVxdibQXvcWe18TjAsnAQ== X-Received: by 2002:a2e:9003:: with SMTP id h3mr41476896ljg.194.1563993180195; Wed, 24 Jul 2019 11:33:00 -0700 (PDT) Received: from [192.168.1.10] (dsl-hkibng22-54f8d6-97.dhcp.inet.fi. [84.248.214.97]) by smtp.gmail.com with ESMTPSA id p9sm8800627lji.107.2019.07.24.11.32.58 (version=TLS1_3 cipher=AEAD-AES128-GCM-SHA256 bits=128/128); Wed, 24 Jul 2019 11:32:59 -0700 (PDT) Subject: Re: GiST VACUUM To: Peter Geoghegan Cc: Thomas Munro , Michael Paquier , Andrey Borodin , Robert Haas , pgsql-hackers , =?UTF-8?B?0JrQvtGB0YLRjyDQmtGD0LfQvdC10YbQvtCy?= References: <36666F0F-F00A-4B44-97F9-F65223CA19CA@yandex-team.ru> <738ecf7d-abc1-ed64-6af7-09eb6d9f3d2f@iki.fi> <4bf0968d-22a2-c7a7-9fd9-bd608da2ad2f@iki.fi> <025ee75c-3960-a8d0-2278-af44ae6feb94@iki.fi> <835A15A5-F1B4-4446-A711-BF48357EB602@yandex-team.ru> <5f7ed675-d1fc-66ef-f316-645080ff9625@iki.fi> <68d00017-ae5c-b14f-fc3a-c9e38e3ce792@iki.fi> <4E1402A8-C05E-4087-B419-03FF5DDA4FB2@yandex-team.ru> <4732efe3-9d96-58cb-a5ce-3f45b9f16ae8@iki.fi> <6D4AAC25-CB7F-42D1-9757-D9FE3F418743@yandex-team.ru> <20190626023309.GG1714@paquier.xyz> <2a45714a-6973-0b5d-e78b-b56618fce17b@iki.fi> From: Heikki Linnakangas Message-ID: <135dfb36-e1d5-fd93-83b0-43c0b6ecf290@iki.fi> Date: Wed, 24 Jul 2019 21:32:58 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.7.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 24/07/2019 21:02, Peter Geoghegan wrote: > On Wed, Jul 24, 2019 at 10:30 AM Heikki Linnakangas wrote: >> Pushed this now, to master and REL_12_STABLE. >> >> Now, B-tree indexes still have the same problem, in all versions. Any >> volunteers to write a similar fix for B-trees? > > I was hoping that you'd work on it. :-) That's probably how it's going to go, but hey, doesn't hurt to ask :-). > Any reason to think that it's much different to what you've done with GiST? No, it should be very similar. - Heikki