Re: Idea to enhance pgbench by more modes to generate data (multi-TXNs, UNNEST, COPY BINARY)

2025-11-17 Thread Boris Mironov
c for backward compatibility and introduction of new modes for INSERT & COPY versus simply replacing old less efficient logic with new one. Sorry for quite long response. Best regards, Boris From: Ashutosh Bapat Sent: November 16, 2025 11:58 PM To: Boris Mironov Cc: pgsql-h

Re: Idea to enhance pgbench by more modes to generate data (multi-TXNs, UNNEST, COPY BINARY)

2025-11-14 Thread Boris Mironov
Hi Ashutosh, > If there is one method that is better than all others, community will > be more willing to accept implementation of that one method than > multiple implementations so as to reduce maintenance burden. Ok then. I'll leave "COPY FROM STDIN BINARY" implementation out of 3 only. Would y

Idea to enhance pgbench by more modes to generate data (multi-TXNs, UNNEST, COPY BINARY)

2025-11-11 Thread Boris Mironov
Hello hackers, For some of my specific hardware tests I needed to generate big databases well beyond RAM size. Hence I turned to pgbench tool and its default 2 modes for client- and server-side generation for TPC-B tests. When I use "scale" factor in range of few thousands (eg, 3000 - 5000) dat