Re: LibPQ: PQresultMemorySize as proxy to transfered bytes - Mailing list pgsql-general

From Dominique Devienne
Subject Re: LibPQ: PQresultMemorySize as proxy to transfered bytes
Date
Msg-id CAFCRh-9Pm-7UigRSCfmC0GnFXigq8ZjKL3_m63FkUWccUtdChw@mail.gmail.com
Whole thread Raw
In response to Re: LibPQ: PQresultMemorySize as proxy to transfered bytes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Wed, Jun 28, 2023 at 1:22 PM Tom Lane <tgl@sss.pgh.pa.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. 

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Wrong passwords allowed
Next
From: Dominique Devienne
Date:
Subject: Topological sort of tables, based on FK relationships