Re: libpq: PQgetCopyData() and allocation overhead

From: Jelte Fennema <postgres(at)jeltef(dot)nl>
To: Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>
Cc: Jeroen Vermeulen <jtvjtv(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: libpq: PQgetCopyData() and allocation overhead
Date: 2023-02-27 14:33:42
Message-ID: CAGECzQQQXdwL3CU7KoaJnmkcPafeavLUkTt1gTnO1cU4R27oVg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Instead of implementing new growable buffer logic in this patch. It
seems much nicer to reuse the already existing PQExpBuffer type for
this patch.

On Mon, 27 Feb 2023 at 14:48, Bharath Rupireddy
<bharath(dot)rupireddyforpostgres(at)gmail(dot)com> wrote:
>
> On Fri, Feb 10, 2023 at 5:49 PM Jeroen Vermeulen <jtvjtv(at)gmail(dot)com> wrote:
> >
> > OK, I've updated the PR with a benchmark (in the main directory).
> >
> > On this benchmark I'm seeing about a 24% reduction in "user" CPU time, and a 8% reduction in "system" CPU time. (Almost no reduction in wall-clock time.)
>
> I can help run some logical replication performance benchmarks
> tomorrow. Would you mind cleaning the PR and providing the changes
> (there are multiple commits in the PR) as a single patch here for the
> sake of ease of review and test?
>
> --
> Bharath Rupireddy
> PostgreSQL Contributors Team
> RDS Open Source Databases
> Amazon Web Services: https://aws.amazon.com
>
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2023-02-27 14:34:54 meson / pg_regress --no-locale
Previous Message gkokolatos 2023-02-27 14:33:04 Re: Add LZ4 compression in pg_dump