PGresult pointer and memory usage

From: Jeff Davis <jdavis-pgsql(at)empires(dot)org>
To: PgSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: PGresult pointer and memory usage
Date: 2005-01-24 20:14:09
Message-ID: 1106597649.2886.777.camel@jeff
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

When you do a PQexec call in libpq, does PostgreSQL produce the entire
result in memory on the server side, and then does libpq hold the entire
result in memory after it retrieves it?

The only time that the server sends parts of the result at a time is
with a cursor, right? And libpq always holds the data that it gets back,
right?

I guess what I'm asking is, where is the PGresult data actually stored,
and how much of it is stored in the client application at a time?

Regards,
Jeff Davis

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mstory 2005-01-24 20:48:18 Re: Calculating a moving average (Coding style)
Previous Message Eric Merritt 2005-01-24 20:13:00 What is the format of 'binary' data in the postgresql client/server protocol version 3