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 1pdL2A-0002Ia-J8 for pgsql-hackers@arkaria.postgresql.org; Sat, 18 Mar 2023 01:06:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pdL29-0006ye-AI for pgsql-hackers@arkaria.postgresql.org; Sat, 18 Mar 2023 01:06:57 +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 1pdL28-0006yV-Uj for pgsql-hackers@lists.postgresql.org; Sat, 18 Mar 2023 01:06:57 +0000 Received: from mail-pj1-x102b.google.com ([2607:f8b0:4864:20::102b]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pdL25-00067l-9J for pgsql-hackers@lists.postgresql.org; Sat, 18 Mar 2023 01:06:56 +0000 Received: by mail-pj1-x102b.google.com with SMTP id gp15-20020a17090adf0f00b0023d1bbd9f9eso11028241pjb.0 for ; Fri, 17 Mar 2023 18:06:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; t=1679101611; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=RBkv60B2R58NpsEoYRe/qVaCzJ84s36wW9nvhZfQYg4=; b=aM++gbySDQCtHpbdeJpzk4xNHRxwg41DjW7ySx3iAoXlsVmeIemA5TCj41D36f3Oqu 6hJa3CagUTatmJzDG8EQ29PrDbqeeK88yPFbUWe+Tpqj2ZxDQhd0NfX9dY/Rk6+T9g6w 0p7VCtxHMwONvyRuarw9UXD6ubqxsnw8CmBSJY/zQwB3MEGTBFyvijuLga0+Ws1yZ4cM qjYCyAMNatQ1ypHOeP30jDFXFNDno5t5isHnKB07vQ2lNGrTCwQ6mX//MZZJvhuAAG69 /udHmL84O3gm9foHd/UpZT/B88NJhpqTltjyVaSAVrx522KvB6p/tZtZEBLLzEh/mx1f k7Yg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1679101611; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=RBkv60B2R58NpsEoYRe/qVaCzJ84s36wW9nvhZfQYg4=; b=xgH61p/nnYEr1OqPHdnEwkgZV4JZXAObI7dFXAbaI1cecpXKrBSXf4BFO5Oe2Y0uyT Qxo3Sit/KnjvwPjdIPlcKPY9lW4x7ppKKl9kj1ulEKzuvOF43CwJXbWli48fdlZ8zOKM T7+I0AYg7eEd1BM/HTgLTziz+xGtr3T5UgA+d+hp/EMAaBIZyKlRnen0mYiXMPePg6pD FnTC3wRYviOwVGgEXfi07x4BTv6ol8xMgw+Zuz0MrAf4XwLGD1Y5U62OV8ZsoWtOfbz4 rp1ws9Ws7nv1NmotQblghlwAzbDYsReoDFnoQDYiWOYatFmo44IdvGP+LJYCQ4SDUW7F mbOA== X-Gm-Message-State: AO0yUKUiNSpNqY34aMjr/U6zWZBNdq9IJEUrsnxXQjz5DOMttcbi0uvd xf7Gz17gyiGGg1ny9A9g9xs= X-Google-Smtp-Source: AK7set8DFqeje4JzscUPAuoE8cKHqcVygihLRoVSHjjW+SxTRGjBB9SZz4KpxfS+XSIoZMvK2gt6Ug== X-Received: by 2002:a05:6a20:72a0:b0:cc:f047:afb4 with SMTP id o32-20020a056a2072a000b000ccf047afb4mr11637970pzk.37.1679101610906; Fri, 17 Mar 2023 18:06:50 -0700 (PDT) Received: from jrouhaud (2001-b011-1005-9ed9-e92f-f682-431d-4205.dynamic-ip6.hinet.net. [2001:b011:1005:9ed9:e92f:f682:431d:4205]) by smtp.gmail.com with ESMTPSA id k17-20020a63d111000000b004fbb4a55b64sm2029813pgg.86.2023.03.17.18.06.47 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 17 Mar 2023 18:06:49 -0700 (PDT) Date: Sat, 18 Mar 2023 09:06:43 +0800 From: Julien Rouhaud To: Tom Lane Cc: Andrew Dunstan , Alvaro Herrera , David Rowley , Peter Geoghegan , Robert Haas , pgsql-hackers@lists.postgresql.org, Andrew Subject: Re: pg_dump versus hash partitioning Message-ID: <20230318010643.o4idvzy35eoeinx7@jrouhaud> References: <20230311030154.pg63uspio35h4a6t@jrouhaud> <1078804.1678504214@sss.pgh.pa.us> <20230311033232.g6jgkuzxdawepsbe@jrouhaud> <1602203.1678650412@sss.pgh.pa.us> <20230313083314.pivmgfu36fi4eu2n@jrouhaud> <2441413.1678750752@sss.pgh.pa.us> <20230316090352.v2m2d473fcv5tli6@jrouhaud> <3756156.1678970636@sss.pgh.pa.us> <20230317020720.3752vjir2qhjtrur@jrouhaud> <134704.1679075052@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <134704.1679075052@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Mar 17, 2023 at 01:44:12PM -0400, Tom Lane wrote: > Julien Rouhaud writes: > > On Thu, Mar 16, 2023 at 08:43:56AM -0400, Tom Lane wrote: > >> I think the odds of that yielding a usable dump are nil, so I don't > >> see why we should bother. > > > No objection from me. > > OK, pushed with the discussed changes. Great news, thanks a lot!