Pierre C wrote: > > Does the psql executable have any ability to do a "fetch many", using a > > server-side named cursor, when returning results? It seems like it tries > > to retrieve the query entirely to local memory before printing to > > standard out. > > I think it grabs the whole result set to calculate the display column > widths. I think there is an option to tweak this but don't remember which, > have a look at the psql commands (\?), formatting section. See the FETCH_COUNT variable mentioned in the psql manual page. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
