Re: pgbench - refactor init functions with buffers
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@anarazel.de>
Cc: Fabien COELHO <coelho@cri.ensmp.fr>, David Steele <david@pgmasters.net>,
Jeevan Ladhe <jeevan.ladhe@enterprisedb.com>,
Dilip Kumar <dilipbalaut@gmail.com>,
PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2020-03-28T18:49:31Z
Lists: pgsql-hackers
Andres Freund <andres@anarazel.de> writes: > On 2020-03-27 19:57:12 -0400, Tom Lane wrote: >> That being the case, I'd think a better design principle is "make your >> new code look like the code around it", which would tend to weigh against >> introducing StringInfo uses into pgbench when there's none there now and >> a bunch of PQExpBuffer instead. So I can't help thinking the advice >> you're being given here is suspect. > I don't agree with this. This is a "fresh" usage of StringInfo. That's > different to adding one new printed line among others built with > pqexpbuffer. If we continue adding large numbers of new uses of both > pieces of infrastructure, we're just making things more confusing. Why? I'm not aware of any intention to deprecate/remove PQExpBuffer, and I doubt it'd be a good thing to try. It does some things that StringInfo won't, notably cope with OOM without crashing. regards, tom lane
Commits
-
pgbench: Use PQExpBuffer to simplify code that constructs SQL.
- 9796f455c38e 14.0 landed
-
Make command order in test more sensible
- ad4b7aeb8443 13.0 cited