pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dominique Devienne <ddevienne@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: LibPQ: PQresultMemorySize as proxy to transfered bytes
Date: Wed, 28 Jun 2023 07:16:27 -0400
Message-ID: <1140652.1687950987@sss.pgh.pa.us> (raw)
In-Reply-To: <CAFCRh-9MoKJjv4J156RvOtg5hmMXM7XPqNYMQVqijkezQq5tug@mail.gmail.com>
References: <CAFCRh-9MoKJjv4J156RvOtg5hmMXM7XPqNYMQVqijkezQq5tug@mail.gmail.com>

Dominique Devienne <ddevienne@gmail.com> writes:
> Obviously from these results, I now realize PQresultMemorySize() returns
> something larger than what went across the network. Can someone explain
> how so?

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) then the
value could be pretty far off what went across the network.
A larger result set should show less percentage error.

			regards, tom lane





view thread (5+ messages)  latest in thread

Message-ID: <1140652.1687950987@sss.pgh.pa.us>
Permalink:  ../1140652.1687950987@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1140652.1687950987@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: tgl@sss.pgh.pa.us, ddevienne@gmail.com
  Subject: Re: LibPQ: PQresultMemorySize as proxy to transfered bytes
  In-Reply-To: <1140652.1687950987@sss.pgh.pa.us>
  References: <CAFCRh-9MoKJjv4J156RvOtg5hmMXM7XPqNYMQVqijkezQq5tug@mail.gmail.com> <1140652.1687950987@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox