Re: libpq - lack of support to set the fetch size

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: libpq - lack of support to set the fetch size
Date: 2014-04-02 22:07:34
Message-ID: 06271b82b31649dd024236fa7886e1c3@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)turnstep(dot)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-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jacob Scott 2014-04-02 22:08:04 Is it safe to stop postgres in between pg_start_backup and pg_stop_backup?
Previous Message Merlin Moncure 2014-04-02 21:57:09 Re: Lock problem