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 1nMwfx-00056y-43 for pgsql-hackers@arkaria.postgresql.org; Wed, 23 Feb 2022 18:47:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nMwfv-0001dX-NB for pgsql-hackers@arkaria.postgresql.org; Wed, 23 Feb 2022 18:47:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nMwfv-0001dN-A3 for pgsql-hackers@lists.postgresql.org; Wed, 23 Feb 2022 18:47:43 +0000 Received: from mail-io1-xd33.google.com ([2607:f8b0:4864:20::d33]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nMwfo-0001Jr-77 for pgsql-hackers@lists.postgresql.org; Wed, 23 Feb 2022 18:47:42 +0000 Received: by mail-io1-xd33.google.com with SMTP id w7so25636462ioj.5 for ; Wed, 23 Feb 2022 10:47:35 -0800 (PST) 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=qQ7Al342v98Dqhqmd/pP9BpILJ2r1muA0OHzV5Do3Tg=; b=55Z4HO1fsajo802biKIZzwTS6mhkhxh/zCjIAK42BA31TqmG+PIsccXPWK09TY4Ca7 snkKZDK3F+2F2DjA1VNlEQTZQhPTDkHL4dSuegwTadQ5rvP8qEbwzkLJnAkLIdyViYZ2 +6V/GIPKZRMb9emDbCPLhxAtJT4WFBjPbdzw6L33IgNrkMdkbddwS7ruE6e15Cx3WQNT UnX2qm7WiQunsnLNzuaD865/9Wsds70X9bqNm3rbVM06spZTaVUXvnrl3DGgImboXfqa xs1sZnV8Nlc0iJnPIbPM+Ofi2A0IPJjxxAvq9MfpQ6CT6OMEm8fzz8EofC9hsNkk572/ Bi7g== 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=qQ7Al342v98Dqhqmd/pP9BpILJ2r1muA0OHzV5Do3Tg=; b=aWWPqZdmAexQl2bwHVXLPvfVTQDdO9lmk8Foi6bXbud2kOu6AQVjepp7YzFkFWgl6W MefB5a70hXu80wEJeUoQxKzhDGQ0kAqMD+30NxDDFzCrgAbVVggTN+fJ1yGmMN9HRhjD Cl1bgL5hemAkFq2drUGDTIlkwIxJjT5AvZdZSlhgYrCP4YBHcMU6TGkw5FdLoQpChQ/h 0RlBmkSUZ4UCvsN1UaZ8M3FCmza+naIN79H8gOI2eLI30QQzS4gnj8hAsUwXDMzAdoZR r8cmjaibto0S8ldcHmxi7X8IIIixbIsiWzan2ffDylPz10fg+A/ooWS7cfXmAaQVhTtO 7BzA== X-Gm-Message-State: AOAM533sh4VM9r7O2DgUXrFOTuIJpsjwC0I0IS7kJk7Q0rhJib42FMB5 O4IRcBky1E019U7mIez2fMbn7Q== X-Google-Smtp-Source: ABdhPJxPUxz0yLEaYp/3xxL8PPLLcp9DKgSeIxSBgu9Bl587tZjYYofAyultPphuS9EmwmeVi82/zQ== X-Received: by 2002:a05:6602:491:b0:60f:ac3a:f3c3 with SMTP id y17-20020a056602049100b0060fac3af3c3mr577254iov.210.1645642053928; Wed, 23 Feb 2022 10:47:33 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id b6sm251156ilo.57.2022.02.23.10.47.33 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 23 Feb 2022 10:47:33 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 7C19880073B; Wed, 23 Feb 2022 12:47:32 -0600 (CST) Date: Wed, 23 Feb 2022 12:47:32 -0600 From: Justin Pryzby To: Alvaro Herrera Cc: Michael Paquier , =?utf-8?B?5p2O5p2wKOaFjui/vSk=?= , pgsql-hackers@lists.postgresql.org, =?utf-8?B?5pu+5paH5peMKOS5ieS7jik=?= , Zhihong Yu Subject: Re: CLUSTER on partitioned index Message-ID: <20220223184732.GN9008@telsasoft.com> References: <20210402200314.GA6592@telsasoft.com> <202107210027.vfv6wn3hvfer@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <202107210027.vfv6wn3hvfer@alvherre.pgsql> 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, Jul 20, 2021 at 08:27:02PM -0400, Alvaro Herrera wrote: > I have to wonder if there really *is* a use case for CLUSTER in the > first place on regular tables, let alone on partitioned tables, which > are likely to be large and thus take a lot of time. What justifies > spending so much time on this implementation? My impression is that > CLUSTER is pretty much a fringe command nowadays, because of the access > exclusive lock required. > > Does anybody actually use it? I hope that Alvaro will comment on the simplified patches. If multiple people think the patch isn't worth it, feel free to close it. But I don't see how complexity could be the reason. -- Justin