Re: LibPQ: PQresultMemorySize as proxy to transfered bytes

From: Dominique Devienne <ddevienne(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: LibPQ: PQresultMemorySize as proxy to transfered bytes
Date: 2023-06-29 08:07:22
Message-ID: CAFCRh-9Pm-7UigRSCfmC0GnFXigq8ZjKL3_m63FkUWccUtdChw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jun 28, 2023 at 1:22 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> I wrote:
> > That number is the total space actually requested from malloc() for
> > the PGresult object. But we request space in blocks (typically 2KB
> > each), so there's some overhead due to fields not exactly filling
> > a block, unused space in the last block, etc. If you're testing
> > with very small result sets (say a couple hundred KB)
>
> Sigh, obviously I meant a couple hundred *bytes* there. -ENOCAFFEINE
>

Thanks Tom. --DD

PS: I was hoping for answers to my other questions too,
but I guess that means there are no good answers to those.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dominique Devienne 2023-06-29 08:21:33 Topological sort of tables, based on FK relationships
Previous Message Adrian Klaver 2023-06-29 01:01:35 Re: Wrong passwords allowed