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

От: John Beaver
Тема: Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout?
Дата: ,
Msg-id: 4BB66D7A.1090605@hms.harvard.edu
(см: обсуждение, исходный текст)
Ответ на: Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout?  ("Pierre C")
Список: pgsql-performance


That makes sense. I'll just use a COPY statement instead like Hannu suggests.<br /><br /> Pierre C wrote: <blockquote
cite="mid:"type="cite"><blockquote type="cite"><pre wrap="">Does the psql executable
haveany 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.   </pre></blockquote><pre wrap="">
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. </pre></blockquote><br /><pre class="moz-signature"
cols="72">--
 
John E. Beaver
Bioinformatics Developer
Harvard Medical School</pre>

В списке pgsql-performance по дате сообщения:

От: John Beaver
Дата:
Сообщение: Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout?
От: David Crooke
Дата:
Сообщение: David Crooke wants to stay in touch on LinkedIn