Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout?

Поиск
Список
Период
Сортировка
От Pierre C
Тема Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout?
Дата
Msg-id op.vajyiejneorkce@immo.peufeu.com
обсуждение исходный текст
Ответ на Does the psql executable support a "fetch many" approach when dumping large queries to stdout?  ("Beaver, John E" <John_Beaver@hms.harvard.edu>)
Ответы 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>)
Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout?  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-performance
Дерево обсуждения 
> 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.

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Beaver, John E"
Дата:
Сообщение: Does the psql executable support a "fetch many" approach when dumping large queries to stdout?
Следующее
От: John Beaver
Дата:
Сообщение: Re: Does the psql executable support a "fetch many" approach when dumping large queries to stdout?