Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout?
От
Bruce Momjian
Тема
Re: *** PROBABLY SPAM *** Does the psql executable
support a "fetch many" approach when dumping large queries to
stdout?
Дата
Msg-id
201004130249.o3D2nUd02232@momjian.us
Ответ на
Список
Дерево обсуждения
Does the psql executable support a "fetch many" approach when
dumping large queries to stdout? "Beaver, John E" <John_Beaver@hms.harvard.edu>
Re: Does the psql executable support a "fetch many"
approach when dumping large queries to stdout? Hannu Krosing <hannu@2ndquadrant.com>
Re: Does the psql executable support a "fetch many" approach
when dumping large queries to stdout? John Beaver <john_beaver@hms.harvard.edu>
Re: *** PROBABLY SPAM *** Does the psql executable support
a "fetch many" approach when dumping large queries to stdout? "Pierre C" <lists@peufeu.com>
Re: *** PROBABLY SPAM *** Does the psql executable
support a "fetch many" approach when dumping large queries to
stdout? Bruce Momjian <bruce@momjian.us>
Re: *** PROBABLY SPAM *** Does the psql executable support
a "fetch many" approach when dumping large queries to stdout? John Beaver <john_beaver@hms.harvard.edu>
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 http://momjian.us EnterpriseDB http://enterprisedb.com
В списке pgsql-performance по дате отправления
От: Kevin Grittner
Дата:
