Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1u0kYP-007BK9-36
	for pgsql-general@arkaria.postgresql.org; Fri, 04 Apr 2025 17:10:05 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1u0kYN-002jKF-M3
	for pgsql-general@arkaria.postgresql.org; Fri, 04 Apr 2025 17:10:03 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1u0kYM-002jGo-I4
	for pgsql-general@lists.postgresql.org; Fri, 04 Apr 2025 17:10:03 +0000
Received: from fhigh-b6-smtp.messagingengine.com ([202.12.124.157])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1u0kYK-002xAO-1i
	for pgsql-general@postgresql.org;
	Fri, 04 Apr 2025 17:10:01 +0000
Received: from phl-compute-02.internal (phl-compute-02.phl.internal [10.202.2.42])
	by mailfhigh.stl.internal (Postfix) with ESMTP id 2B99725401BA;
	Fri,  4 Apr 2025 13:09:59 -0400 (EDT)
Received: from phl-mailfrontend-01 ([10.202.2.162])
  by phl-compute-02.internal (MEProxy); Fri, 04 Apr 2025 13:09:59 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h=
	cc:content-transfer-encoding:content-type:content-type:date:date
	:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to; s=fm1; t=1743786599;
	 x=1743872999; bh=rZh3jfUmlkJUpBIC8+HpqukbfiSSOHJ8qITCEQdzeps=; b=
	ckh+MwmLuAsElzeCOIQ5WKtY6X+/mUXtr1Z1F+RCDabR+l5UtqXFUycsMTh+n/kH
	kkqFAiyZujUpYk5X0YcxKm7AnPw/Pd/ZF3b82X+zzXuVbxwDN+10uuEe89jqMeqM
	+qwO8Mr9gEvyc/lHAZ+XtwbbA/WnGy/eH2KokYelJC5tg3RJT+YHDBBpA9fq5SFD
	IAU5+Yw3VvExyzsQkSI49gb/FaDst5JimSzw4QcpnIGCvSAL+GZ5J5u8l+xs1P6N
	WQjTzmM+vSN8Iigug8TFmVPiXZJwM+LudG3SnoFr1KYJEsaXkdLDAMbp3ewx8He/
	UyOA0QzQ5j7+9KRjtxYhzw==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:content-transfer-encoding:content-type
	:content-type:date:date:feedback-id:feedback-id:from:from
	:in-reply-to:in-reply-to:message-id:mime-version:references
	:reply-to:subject:subject:to:to:x-me-proxy:x-me-sender
	:x-me-sender:x-sasl-enc; s=fm2; t=1743786599; x=1743872999; bh=r
	Zh3jfUmlkJUpBIC8+HpqukbfiSSOHJ8qITCEQdzeps=; b=dFSDFy7s0LROaH25L
	Fr/edPnIyAp1sIwsKW+vDrzCfF0u7O2VLagc1+VtPLdw05autW0dEdVfVLzGpJag
	pGBJ574+KZYp24EzuDpC7xWyu4/L+fJqshupPfJfUxKrnIu/s1cYKQ4WH04Ti6iV
	2dcJ5ull18X9FZgtYtieMcPsnRq/aTTCvRjoYid8Ywt26RiWqKJnkZp1ERlt1wqR
	muS1rUxT9dD8IlyAh9k2y72tQAXV7PCDZO3kTB8n8PN0O1rWKIF3/r+vKJA9Akx9
	+slsOtRRsNajyZebVqLVaJxZlvpN73cA7AXbC5AhQTbjNiuAycAxQ9WCf1ztcEOD
	S+s8Q==
X-ME-Sender: <xms:ZhLwZ19tvg0MtYXeoZ30UbNw2EAI4Cd0UKuPoo5ztvUeO39zPJ109A>
    <xme:ZhLwZ5sH4m22--FRXmZjRAS7MIFSoXoZFrkNM-kyDNX-0Z4OdNQqlPnqyiW324Iwb
    GjPd2Ouxm9yoLs>
X-ME-Received: <xmr:ZhLwZzDXVkCJibWo0NksWnqWoYay5y-b_QMANI8ceXe4jTSCvYAyaeDmVoP9zIusg7Cys0AVoHBt9JdCFq1ij48H037TAp7HsIkT8UQ0IQ>
X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgdduledvtddtucetufdoteggodetrf
    dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv
    pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucenucfjughrpefkff
    ggfgfuvfhfhfgjtgfgsehtkeertddtvdejnecuhfhrohhmpeetughrihgrnhcumfhlrghv
    vghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomheqnecuggftrf
    grthhtvghrnhepleegveekkeekueeigfdtveeileeuhfefudefteekjeffkeejueejheeg
    heegkedtnecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghenucevlhhushhtvg
    hrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghv
    vghrsegrkhhlrghvvghrrdgtohhmpdhnsggprhgtphhtthhopedvpdhmohguvgepshhmth
    hpohhuthdprhgtphhtthhopehrohhnlhhjohhhnhhsohhnjhhrsehgmhgrihhlrdgtohhm
    pdhrtghpthhtohepphhgshhqlhdqghgvnhgvrhgrlhesphhoshhtghhrvghsqhhlrdhorh
    hg
X-ME-Proxy: <xmx:ZhLwZ5crcq958QyJFynAWv36wnlpJb3ZTir__H66QvyVbVQUZihetA>
    <xmx:ZhLwZ6P9PaR-3epLeh3ePUjhIaM4e3GgYhMXv7MTbV_yQWV9KgUqug>
    <xmx:ZhLwZ7kMcE2q0L5y7bCH5EDdbrBxcHv-TwQ18hzi0zS1ANro0RsrOA>
    <xmx:ZhLwZ0syTT9p_3jik7RUepE2SrABMg8JQ32TsZJqNEokU5bryz8iPQ>
    <xmx:ZxLwZxWMjR8wyG5rdF9Z5_223rq8_SKJWZdg4D1ry5lDiqIUHBvBJ4d->
Feedback-ID: i76984098:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri,
 4 Apr 2025 13:09:57 -0400 (EDT)
Message-ID: <4955ab9f-30df-4293-bd43-257faf265ac9@aklaver.com>
Date: Fri, 4 Apr 2025 10:09:56 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Performance issues during pg_restore -j with big partitioned
 table
To: Ron Johnson <ronljohnsonjr@gmail.com>,
 pgsql-general <pgsql-general@postgresql.org>
References: <84379bfb-bbda-84e6-cacc-e863ba9d6c37@gmx.net>
 <CANzqJaD0+Mex1tCj6i0SbQK0Z3urqYYN5GUC=7PntGe4DNVgtQ@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CANzqJaD0+Mex1tCj6i0SbQK0Z3urqYYN5GUC=7PntGe4DNVgtQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/4955ab9f-30df-4293-bd43-257faf265ac9%40aklaver.com>
Precedence: bulk



On 4/4/25 9:45 AM, Ron Johnson wrote:

> 
> TRUNCATE statements inside of "toc.dat" files?  I'm skeptical.

See my post here:

https://www.postgresql.org/message-id/7be2dcc6-3ba4-4e3f-a154-8d13d816aa9b%40aklaver.com



-- 
Adrian Klaver
adrian.klaver@aklaver.com