Re: libpq - lack of support to set the fetch size - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: libpq - lack of support to set the fetch size
Date
Msg-id 06271b82b31649dd024236fa7886e1c3@biglumber.com
Whole thread Raw
In response to Re: libpq - lack of support to set the fetch size  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> Second, the feature needed to do this without even
> using a cursor was added 1.5 years ago (PQsetSingleRowMode).  The DBD::Pg
> was just not taught how to use it yet.

True. And we were hoping for something better, so we can make one request
for 10,000 rows to libpq rather than call PQgetResult 10,000 times, but
we'll move ahead with implementing RowCacheSize via PQsetSingleRowMode.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 201404021428
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAlM8ie8ACgkQvJuQZxSWSsit0gCgn0qMRRnep2sVUeM+BLyQoIkS
dtMAoPvM71oL+YdQg+84/xT2TxLj3wek
=GVH+
-----END PGP SIGNATURE-----




pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Lock problem
Next
From: Shaun Thomas
Date:
Subject: Re: SSD Drives