Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow response from 'SELECT * FROM table' - Mailing list pgsql-performance

From Andrew Sullivan
Subject Re: Slow response from 'SELECT * FROM table'
Date
Msg-id 20021111125950.L4386@mail.libertyrms.com
Whole thread Raw
In response to Re: Slow response from 'SELECT * FROM table'  (Wei Weng <wweng@kencast.com>)
List pgsql-performance
Tree view 
On Mon, Nov 11, 2002 at 12:19:47PM -0500, Wei Weng wrote:
> I am curious, what performance difference does it make to use vanilla
> SELECT with to use cursor (for retrieving the entire records)?

If you use a cursor, you don't need to buffer the entire record set
before returning it.

A
--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110

pgsql-performance by date:

Previous
From: Mike Nielsen
Date:
Subject: Query performance discontinuity
Next
From: Josh Berkus
Date:
Subject: Re: Query performance discontinuity