Re: pgbench: INSERT workload, FK indexes, filler fix

2021-07-01 Thread David Christensen
Fabien COELHO writes: > Hello Greg, > > Some quick feedback about the patch and the arguments. > > Filling: having an empty string/NULL has been bothering me for some time. > However there is a > significant impact on the client/server network stream while initializing or > running queries,

Re: pgbench: INSERT workload, FK indexes, filler fix

2021-07-01 Thread Fabien COELHO
Hello Greg, Some quick feedback about the patch and the arguments. Filling: having an empty string/NULL has been bothering me for some time. However there is a significant impact on the client/server network stream while initializing or running queries, which means that pgbench older

pgbench: INSERT workload, FK indexes, filler fix

2021-06-30 Thread Gregory Smith
Attached is a combined diff for a set of related patches to the built-in pgbench workloads. One commit adds an INSERT workload. One fixes the long standing 0 length filler issue. A new --extra-indexes option adds the indexes needed for lookups added by the --foreign-keys option. The commits