Re: Re: [COMMITTERS] pgsql: pgbench: Allow the transaction log file prefix to be changed.

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: [COMMITTERS] pgsql: pgbench: Allow the transaction log file prefix to be changed.
Date: 2016-11-10 04:17:00
Message-ID: CA+TgmoZcOQeJHe=_oNyeQScdkRcdMrrN+wZBfq5gyR=aAHm4OA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On Wed, Nov 9, 2016 at 10:08 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Robert Haas <robertmhaas(at)gmail(dot)com> writes:
>> On Wed, Nov 9, 2016 at 4:51 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> Perhaps the "logpath" buffer that the filename is constructed in
>>> needs to be made bigger. 64 bytes was obviously enough with the
>>> old pattern, but it's not with the new.
>
>> Oops, yes, that seems like a good idea. How about 64 -> MAXPGPATH?
>
> If we want to stick with the fixed-size-buffer-on-stack approach,
> that would be the thing to use. psprintf is another possibility,
> though that would add a malloc/free cycle.

I don't think the performance cost of a malloc/free cycle would be
noticeable, but I don't see much point in it, either. It's likely
that, if you hadn't notice this by inspection, we could have gone a
few years before anyone ran afoul of the 64-character limit. Now,
MAXPGPATH is 1024, and I do not know too many people who have a real
need for pathnames over 1024 characters. I think we may as well just
keep it simple.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2016-11-10 15:37:17 pgsql: Doc: improve link.
Previous Message Michael Paquier 2016-11-10 03:12:10 Re: Re: [COMMITTERS] pgsql: pgbench: Allow the transaction log file prefix to be changed.

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2016-11-10 04:29:18 Re: pg_sequence catalog
Previous Message Amit Kapila 2016-11-10 04:04:04 Re: Hash Indexes