diff options
| author | Melanie Plageman <melanieplageman@gmail.com> | 2025-02-11 16:51:28 -0500 |
|---|---|---|
| committer | Melanie Plageman <melanieplageman@gmail.com> | 2025-02-11 16:52:08 -0500 |
| commit | d0d649e91685081e6c5334d6d01ab4cd735b397d (patch) | |
| tree | 37c8b56fca14104d34ed7ee8b05c04ac49b350e1 /doc/src | |
| parent | 38172d1856b34792a5ee60eaa0d883166e90d33d (diff) | |
| download | postgresql-d0d649e91685081e6c5334d6d01ab4cd735b397d.tar.gz postgresql-d0d649e91685081e6c5334d6d01ab4cd735b397d.zip | |
Limit pgbench COPY FREEZE to ordinary relations
pgbench client-side data generation uses COPY FREEZE to load data for most
tables. COPY FREEZE isn't supported for partitioned tables and since pgbench
only supports partitioning pgbench_accounts, pgbench used a hard-coded check to
skip COPY FREEZE and use plain COPY for a partitioned pgbench_accounts.
If the user has manually partitioned one of the other pgbench tables, this
causes client-side data generation to error out with:
ERROR: cannot perform COPY FREEZE on a partitioned table
Fix this by limiting COPY FREEZE to ordinary tables (RELKIND_RELATION).
Author: Sergey Tatarintsev <s.tatarintsev@postgrespro.ru>
Reviewed-by: Álvaro Herrera <alvherre@alvh.no-ip.org>
Discussion: https://postgr.es/m/flat/97f55fca-8a7b-4da8-b413-7d1c57010676%40postgrespro.ru
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/pgbench.sgml | 9 |
1 files changed, 4 insertions, 5 deletions
diff --git a/doc/src/sgml/ref/pgbench.sgml b/doc/src/sgml/ref/pgbench.sgml index 46240e3f725..3f488b44d7b 100644 --- a/doc/src/sgml/ref/pgbench.sgml +++ b/doc/src/sgml/ref/pgbench.sgml @@ -231,11 +231,10 @@ pgbench <optional> <replaceable>options</replaceable> </optional> <replaceable>d sent to the server. This uses the client/server bandwidth extensively through a <command>COPY</command>. <command>pgbench</command> uses the <option>FREEZE</option> option - with version 14 or later - of <productname>PostgreSQL</productname> to speed up - subsequent <command>VACUUM</command>, except on the - <literal>pgbench_accounts</literal> table if partitions are - enabled. Using <literal>g</literal> causes logging to + to load data into ordinary (non-partition) tables with version 14 + or later of <productname>PostgreSQL</productname> to speed up + subsequent <command>VACUUM</command>. + Using <literal>g</literal> causes logging to print one message every 100,000 rows while generating data for all tables. </para> |