Re: libpq, PQexecPrepared, data size sent to FE vs. FETCH_COUNT - Mailing list pgsql-hackers

From Alex Goncharov
Subject Re: libpq, PQexecPrepared, data size sent to FE vs. FETCH_COUNT
Date
Msg-id E1OGu0I-000FOv-7b@daland.home
Whole thread Raw
In response to Re: libpq, PQexecPrepared, data size sent to FE vs. FETCH_COUNT  (Abhijit Menon-Sen <ams@toroid.org>)
List pgsql-hackers
,--- Abhijit Menon-Sen (Tue, 25 May 2010 17:26:18 +0530) ----*
| Unless you explicitly declare and fetch from an SQL-level cursor, your
| many GBs of data are going to be transmitted to libpq, which will eat
| lots of memory. (The wire protocol does have something like cursors,
| but libpq does not use them, it retrieves the entire result set.)
,--- Yeb Havinga (Tue, 25 May 2010 14:08:51 +0200) ----*
| The GBs of data are gathered at the site of the libpq client (pgresult 
| object gathered/allocated while consuming result input from backend).
`------------------------------------------------------*

Thank you very much!

-- Alex -- alex-goncharov@comcast.net --


pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: ExecutorCheckPerms() hook
Next
From: Robert Haas
Date:
Subject: Re: pg_upgrade docs