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.92) (envelope-from ) id 1jDqgM-0006HZ-IM for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Mar 2020 14:25:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jDqgL-0004GD-BY for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Mar 2020 14:25:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1jDqgK-0004G6-VV for pgsql-hackers@lists.postgresql.org; Mon, 16 Mar 2020 14:25:29 +0000 Received: from mail-qk1-x743.google.com ([2607:f8b0:4864:20::743]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jDqgI-0000nS-LS for pgsql-hackers@postgresql.org; Mon, 16 Mar 2020 14:25:27 +0000 Received: by mail-qk1-x743.google.com with SMTP id f28so26403987qkk.13 for ; Mon, 16 Mar 2020 07:25:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=0PqR6/DjiH+g4wrSXvtVPTSUnkvb1yNTIQJ98WkCMVk=; b=HaDl5nAMYxjJ1acuvzJolHd+1bLA1eliXASJTzvc5mqxg77QKIOn+sDShpnmjTDiCb wLGbLyY1vFuH0TJkjfGKb3VKFAMX0/yo1s+8/OqUSffJWtTFA4vtEOYb0UmKisu0gLjl oouMaD4CDiNhRf92x91CzRfn1sbNfdUmghWwyoCLOQ7LMTCT6SmRZ2/WT27oCq/KuN1x njNOR9ao/OBjg2joBjFnoJ5d8FrM2M4caXjiyP+ixYNdP58nttSgD6dC0fhDzvfVzb+M 1sZwGrkvIHM5MbyUdymlwvFcD1Y/YVBOSAyRQgydS59oC4Bg1RykVnePCzHh5p8xPVXL 4gDA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=0PqR6/DjiH+g4wrSXvtVPTSUnkvb1yNTIQJ98WkCMVk=; b=cjYrjH6Dkw6+VdifdefeygcZ7ETibAom+UEol37eonSccEH3lhAF9pTwxMoPZHkTiZ 7hqKr5XbUuKWsRfeGCjRtf5+TY0lAcBxfZX03+ytXUBhbi3RFOftI8NIARNdQtRzGmt3 7hZkHpQPdAudqvsLT3emyGQ+mzYRf/AB+T5TdJi5u2CANdswG3gOPlf+bWb5/BdF7gZe T5+iJILS2b5GC2vzMWfcysJjSdKnJQdRAzfa6gluloXZpPQqkwiViHaAReX9T6ZG6FKM hzBYiTQ0+YodVDIyD2ZeMY+ZmBOCHW9bvmfTafWQn+us7RBwkn5R5RaagArKazRreG7h U/jw== X-Gm-Message-State: ANhLgQ1hqHiWEIbraaTrS9TDoBO6CJvT8FpxY4px0BicpdiRkJY+gVYd 9fkL0CiLmhiZzV4FdaKKMX7JCyX7iQc= X-Google-Smtp-Source: ADFU+vvt3cV2crVXCsZ9I/sI1o31MCq4Oam83YtUiBarZGoIMiZBkuJAvd5d1wW4a0uElYrKB7fWJg== X-Received: by 2002:a37:9ecc:: with SMTP id h195mr24489058qke.448.1584368726027; Mon, 16 Mar 2020 07:25:26 -0700 (PDT) Received: from nimloth.alvh.no-ip.org ([201.186.208.119]) by smtp.gmail.com with ESMTPSA id x22sm14816670qki.54.2020.03.16.07.25.25 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 16 Mar 2020 07:25:25 -0700 (PDT) Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000) id 50EC630085E; Mon, 16 Mar 2020 11:25:23 -0300 (-03) Date: Mon, 16 Mar 2020 11:25:23 -0300 From: Alvaro Herrera To: Justin Pryzby Cc: Amit Langote , Tom Lane , Michael Paquier , pgsql-hackers@postgresql.org Subject: Re: ALTER tbl rewrite loses CLUSTER ON index Message-ID: <20200316142523.GA14606@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20200316132731.GJ26184@telsasoft.com> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-Mar-16, Justin Pryzby wrote: > Also, should we call it "is_index_clustered", since otherwise it sounds alot > like "+get_index_clustered" (without "is"), which sounds like it takes a table > and returns which index is clustered. That might be just as useful for some of > these callers. Amit's proposed name seems to match lsyscache.c usual conventions better. > Should we use your get_index_isclustered more widely ? Yeah, in cluster(), mark_index_clustered(). -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services