Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group