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 1q9RgX-0007oK-Ih for pgsql-hackers@arkaria.postgresql.org; Wed, 14 Jun 2023 14:41:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q9RgW-000763-AN for pgsql-hackers@arkaria.postgresql.org; Wed, 14 Jun 2023 14:41:20 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q9RgV-00075r-Ss for pgsql-hackers@lists.postgresql.org; Wed, 14 Jun 2023 14:41:20 +0000 Received: from mail-oo1-xc36.google.com ([2607:f8b0:4864:20::c36]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1q9RgS-002Ahu-87 for pgsql-hackers@postgresql.org; Wed, 14 Jun 2023 14:41:18 +0000 Received: by mail-oo1-xc36.google.com with SMTP id 006d021491bc7-559409cc490so631219eaf.3 for ; Wed, 14 Jun 2023 07:41:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=neon-tech.20221208.gappssmtp.com; s=20221208; t=1686753675; x=1689345675; h=in-reply-to:references:message-id:from:to:subject:date :content-transfer-encoding:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=dXIeiRyhgPY3iamQZW8XVm6BgeQb2O2ver/8EaYNLHQ=; b=b40F1W9t0uwtDCB1MRBnRtMI+1WVdi21VNZk1uC5rL/ftuTycdsNiefpMqP46hiKn/ VNXRy+8PklPuiuL5gGOS8jANUnDBQ8NT+P1L7FWHpEqekoXBB/ihH44+GPramFYs8jdl PcguJdWi7ZVXLix68lDdbToP0QcVNGoFgyZmJd5dLXrnumlleSw8fUMq19M0DsT5wja8 ymBzCIIw3oY0kvW6+GqKzY4vJh1w52ASYnGqhyIDQZslZmz94wJMILw6xcdwi9/rJ1io 9iVmjz11k9YQ8ohjWqP49JFNqRbVWQvDBEsDOZstA0+RHpWVnmNTMvy01oHyORGhkCnb pUKg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1686753675; x=1689345675; h=in-reply-to:references:message-id:from:to:subject:date :content-transfer-encoding:mime-version:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=dXIeiRyhgPY3iamQZW8XVm6BgeQb2O2ver/8EaYNLHQ=; b=NqLJ7qumaPdl1/BjNg9ZDqAYeZn6JTkcWGiaMWjdLZ29SgNWqq3p/Xeg9xzkrgFLAL XoOwBNU0UyGabPEZ9xKIi5+W0HulV98W222hxzFf3uICli/fhtKK568CsPaKEwHujWCW UqrQ7m+AoZAFDcqQksI67u2le0Fc2XMiBylb+fHx5MJmdAL4UB6j4azDeUd6sRV5XVfw SbPY7bz2kHWqKXyzPT8oB1yL0Xs3rwGyPgYWP9k81l1L0oaQ2JxsRp18SCbGgm/VaNMO deTe5HUMGNfrJ6XxehC4OjRcuykpC4XNoeazo4mJ9OqJ9MXzZ33ZTW0/MbpRQemJtRAr H6DQ== X-Gm-Message-State: AC+VfDy2Ux2vf3GpkQSLeMegNVqbCHTB/uPyHUqiAGLKwmQ/9XOycFqm y8lHP24ljYV6fmT3nqz5YpkWJWB9B7olG9uSTuk= X-Google-Smtp-Source: ACHHUZ6BWdmtqRMV4PzqkCpRVKdNBague1e4LIeJUN55rg2mjzgGuNrwWn6IGN4Lel6vnkTd3aeikA== X-Received: by 2002:a4a:ead4:0:b0:558:ae64:6533 with SMTP id s20-20020a4aead4000000b00558ae646533mr10225303ooh.8.1686753675473; Wed, 14 Jun 2023 07:41:15 -0700 (PDT) Received: from localhost ([2607:fb90:e696:c1dc:3996:e070:71ee:42fb]) by smtp.gmail.com with ESMTPSA id bg40-20020a056820082800b00558c88d131asm5034360oob.36.2023.06.14.07.41.14 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 14 Jun 2023 07:41:15 -0700 (PDT) Mime-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=UTF-8 Date: Wed, 14 Jun 2023 09:41:14 -0500 Subject: Re: Use COPY for populating all pgbench tables To: "Tristan Partin" , From: "Tristan Partin" Message-Id: X-Mailer: aerc 0.15.2-46-g263d8cbec504 References: In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Here is a v2. It cleans up the output when printing to a tty. The last "x of y tuples" line gets overwritten now, so the final output looks like: dropping old tables... creating tables... generating data (client-side)... vacuuming... creating primary keys... done in 0.14 s (drop tables 0.01 s, create tables 0.01 s, client-side gener= ate 0.05 s, vacuum 0.03 s, primary keys 0.03 s). --=20 Tristan Partin Neon (https://neon.tech)