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 1sWgqv-00Gl3z-Km for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Jul 2024 18:36:41 +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 1sWgqt-007Xo4-Tm for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Jul 2024 18:36:39 +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 ) id 1sWgqt-007Xnv-K8 for pgsql-hackers@lists.postgresql.org; Wed, 24 Jul 2024 18:36:39 +0000 Received: from mail-io1-xd2b.google.com ([2607:f8b0:4864:20::d2b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sWgqq-001FJ5-VD for pgsql-hackers@postgresql.org; Wed, 24 Jul 2024 18:36:38 +0000 Received: by mail-io1-xd2b.google.com with SMTP id ca18e2360f4ac-7f684af6af1so4777139f.2 for ; Wed, 24 Jul 2024 11:36:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1721846196; x=1722450996; darn=postgresql.org; 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=P5AH7Q96b81VgXdEmhjTrryZkxPruXnWiiPgSydFiYs=; b=C9DTssC40krdudtFg23gcsIv4uHkp+mypVV/29k/xcZ+yJLWcmEQjsVGPU9+TGlEzz ixAjPqbxfWGkZ/6eMsiU1EK9TwU6JFZjGIa54N4rhTf72pnszNbBW3V6brIC3eZVYS0O NzZ5krXFiSANkwFudEPhtBHWJUAkIiiP3l03Bb+RY1TjC5oEQ7okl4rKM86BhAqQOz1Z sZBGzz1k5H4Sz6RuPRPkF39PrZoC6Jp387Y6HdF26vBp2k6/dhlJP7cltmeHOgJolqvG dd8+t4YTWekWGsWwLZ7l9x+wbaN77UtKLsogk6zOOsUUICJAoYepN5kKY3rENeaHYJWG zf+Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1721846196; x=1722450996; 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=P5AH7Q96b81VgXdEmhjTrryZkxPruXnWiiPgSydFiYs=; b=urDpnxe1Tsuk1Nf6cH8Iy1bJKVIeTcxV5rBMvo968XEh4futNrGi/xN6mm4OuTFaFN zWjkM3BxwDAYh7BDw3ahES5B1KSvWy4Pb16iguAwrs/lTz/2FlZtdyUJGnZwieXyv/bk 86OgYiACS3DWovFsmIqRKgq0d82uxjIQYsfEeYh4id0or7LB2/o/+MHuVF6R0fYFeCMs eZWFqPvWLx1equebUZ41sFIwGqKdXOu9ieYIekDSxPzvcZrEHlyy4NnYKzyULv/3fJzl cOUxoLLfdvU091M8blgXiJtrQYcmKqeRBprTyJBXjQloaSdeXwzHGOGtn7U3EhtTFwBN klWw== X-Forwarded-Encrypted: i=1; AJvYcCX+xcacaMqBKVTK2FRjue5gS6uIeLExoS+3zvESll0GhVoaiE5TrGMma2WMwc67k4vQw2dqoFpLePYBT0t79OPTk1pktHup1mixHXMj X-Gm-Message-State: AOJu0Yxf2bbZGmgs2xVUHtQKlJBiamINTwODl5ZBXiiDyHrwfclxdRly 20iB/HiUz+Dl7/slxf643saNtKb7ny2aBebXzDRxluoctkIs2nXd X-Google-Smtp-Source: AGHT+IGAkY/k1af+7g4m7meX6RI82CjK5cNk2Kh/7A2kxW0YrWtzNfeCbGGK0Sqvzu5KcLeSBGvu/w== X-Received: by 2002:a05:6602:13c3:b0:807:eeef:4fb5 with SMTP id ca18e2360f4ac-81f7bd127d6mr129715239f.1.1721846196000; Wed, 24 Jul 2024 11:36:36 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 8926c6da1cb9f-4c28c6f05b5sm512716173.43.2024.07.24.11.36.35 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 24 Jul 2024 11:36:35 -0700 (PDT) Date: Wed, 24 Jul 2024 13:36:34 -0500 From: Nathan Bossart To: Tom Lane Cc: Michael Paquier , Euler Taveira , pgsql-hackers Subject: Re: improve performance of pg_dump with many sequences Message-ID: References: <3578088.1721242766@sss.pgh.pa.us> <3585715.1721243507@sss.pgh.pa.us> <3640163.1721275101@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I ran Euler's tests again on the v6 patch set. for i in `seq 1 10000`; do psql postgres -c "CREATE SEQUENCE s$i;"; done time pg_dump -f - -s -d postgres > /dev/null HEAD: 0.607s 0001 + 0002: 0.094s all patches: 0.094s Barring additional feedback, I am planning to commit these patches early next week. -- nathan