Re: Processing database query-results piecemeal

From: Abhijit Menon-Sen <ams(at)oryx(dot)com>
To: "Stephen R(dot) van den Berg" <srb(at)cuci(dot)nl>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Processing database query-results piecemeal
Date: 2008-06-30 11:25:15
Message-ID: 20080630112515.GA21369@toroid.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

At 2008-06-30 13:17:42 +0200, srb(at)cuci(dot)nl wrote:
>
> It seems that the most efficient way to communicate with the
> DB would be through PQexecParams(), which avoids the whole
> bytea-encoding issues.

Yes.

> Does it become $10 or ${10} or $(10) or is it simply not possible
> te reference more than nine parameters this way?

$10 etc.

> - Say that the SELECT returns 1000 rows of 100MB each, is there a way
> to avoid PQexecParams() from wanting to allocate 1000*100MB = 100GB

Use a cursor and keep executing FETCH.

-- ams

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2008-06-30 11:50:26 Re: Git Repository for WITH RECURSIVE and others
Previous Message Stephen R. van den Berg 2008-06-30 11:17:42 Processing database query-results piecemeal