Postgres Pro
Downloads
Home   >   mailing lists

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

From Bruce Momjian
Subject Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout?
Date
Msg-id 201004130249.o3D2nUd02232@momjian.us
Whole thread Raw
In response to Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout?  ("Pierre C" <lists@peufeu.com>)
List pgsql-performance
Tree view 
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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: How to diagnose a *context-switching * storm problem ?
Next
From: norn
Date:
Subject: Re: significant slow down with various LIMIT