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 ) id 1tvbl7-006HQP-RE for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Mar 2025 12:45:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tvbl5-006Nmz-QS for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Mar 2025 12:45:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tvbl5-006Nmr-HO for pgsql-hackers@lists.postgresql.org; Fri, 21 Mar 2025 12:45:55 +0000 Received: from mail-yw1-x112d.google.com ([2607:f8b0:4864:20::112d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tvbl3-000Js5-1N for pgsql-hackers@lists.postgresql.org; Fri, 21 Mar 2025 12:45:55 +0000 Received: by mail-yw1-x112d.google.com with SMTP id 00721157ae682-6feafc707d3so17774967b3.1 for ; Fri, 21 Mar 2025 05:45:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1742561151; x=1743165951; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=/ngEBr3I23K+GHw/cm+sBv8JrV6BXbnPxGBJp+5gO7s=; b=L+z7CqKmXBGgZy0nE7uYwQOPAXp1/tCYOU2HFPE1gXz7ExLqQMn5FfjngH9P+xh9Gi dfvIQ7jSZXXV2pJNjD6f9XXHdwoLkK+4iuUzLB9F3mgZcacv4G3FBjMZ6uUjnnkMk65x 8x+ZH/QdmUw2xC5FWfwc6sh6DxsR86onyfI/FjHX7HFfyB1jadHAassnSOrNKO1ksVEf G6xIpGjpl8qQq1k2vvJ0o73MfnBozL2322wmgxqqvbSYWaNqZ7XwlAPXRQrwCtGwWuVK Ha7jwKGsauar5xxtzXJbRyR7kmpXwgF7g6LJqh87mctm0AsFoMjW8TfaK6hSukJkSd+k iowQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742561151; x=1743165951; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=/ngEBr3I23K+GHw/cm+sBv8JrV6BXbnPxGBJp+5gO7s=; b=LxvcUPn4YrbcBCfLqT3MtX1/LryjGN0iQ7LbLvAglYupja8GQ14Q60wOJn/GOZhuW+ BUvSBLgRvq9zPGR38nBTdDgEFA8m1PGaJXCMPLYeh7PrSbkbGmN0uapFUW1f0/PQlNhN hTn6qPjdvy+bKeZdBZ4/sDzGWfp9DL+XCAhKxSU/STN8ap0zstpHdxSwnPSlgYN0ltEk ex0iFVR9t8ReIMmP6Q29giFE+0QG0havbZgysY12CyeZZKaG5OdVsuZEkkr6D4S4rKuD IXefZx0kR/e5gSANNkiEVOIVW9u+6eVtMKEFHTIIx/66ivWcacJV1RtJgRqyCi78LXSL MUgg== X-Forwarded-Encrypted: i=1; AJvYcCU6lmjd6VYyf88KTVWD6QPSkAPp6jYNZuPHBXh5BhAWiGQafpvFgQbUMbLhhaVPiuhkjxUcJ3Ry4YiHYb5Y@lists.postgresql.org X-Gm-Message-State: AOJu0YwiaB7pgXovij+wz02yqJ7rSIFMQdSmUPBTNow+D2cnMiNkqCXa 9ujZkL4YnzlGh2Ep1ecUJ6jgM3srCvKsC3ZUCwXKYT3QL+yjJp08D9QSthsmgi3JiOlhoXoLvvj oUKCfZzROi/NgboaPP6Ggx9Pw9pA= X-Gm-Gg: ASbGncuKvlBlktrZGxmFYSUkDOpYIZ6PA1z2UArajrnemPOb1WukjffJa/vmF2YBwY0 9gAMbTEtT4Y9lBgWmjwK0NvTtQmdu2Jmt0UiVJfdG6ApgtMEE91X1D36FVSV+oXn0zwdcMqXiFH OrgXELsycFPtsreGtMkUCA25nMmFs8VPRGp+MB1eOLDRh3uptOBFFcTHvWDTht X-Google-Smtp-Source: AGHT+IFyrmVgCrdrBqZGNrmOHHsTSSZ10LylDXdYErX9pYgAUw4WGOAwrN6i6s2MOQUm2b/u8MqVGag+e55syofN6v4= X-Received: by 2002:a05:690c:6007:b0:6fb:a4e6:7d52 with SMTP id 00721157ae682-700bad5eae2mr45430427b3.35.1742561151173; Fri, 21 Mar 2025 05:45:51 -0700 (PDT) MIME-Version: 1.0 References: <202503201639.e4siaal3wgnv@alvherre.pgsql> In-Reply-To: <202503201639.e4siaal3wgnv@alvherre.pgsql> From: vignesh C Date: Fri, 21 Mar 2025 18:15:38 +0530 X-Gm-Features: AQ5f1JoJxAd5GEmmlEs2pQvD7soqB3xyd0gZdb_Orr74BrO4oFOvHB3lSSnxRlk Message-ID: Subject: Re: Test to dump and restore objects left behind by regression To: Alvaro Herrera Cc: Ashutosh Bapat , Michael Paquier , Daniel Gustafsson , Tom Lane , Peter Eisentraut , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 20 Mar 2025 at 22:09, Alvaro Herrera wrote: > > On 2025-Mar-20, vignesh C wrote: > > > Will it help the execution time if we use --jobs in case of pg_dump > > and pg_restore wherever supported: > > As I said in another thread, I think we should enable this test to run > without requiring any PG_TEST_EXTRA, because otherwise the only way to > know about problems is to commit a patch and wait for buildfarm to run > it. Furthermore, I think running all 4 dump format modes is a waste of > time; there isn't any extra coverage by running this test in additional > formats. +1 for running it in only one of the formats. Regards, Vignesh