Re: Slow response from 'SELECT * FROM table'

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow response from 'SELECT * FROM table'
Date: 2002-11-11 17:59:50
Message-ID: 20021111125950.L4386@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Shaun Thomas 2002-11-11 18:08:55 Re: Upgrade to dual processor machine?
Previous Message Mike Nielsen 2002-11-11 17:44:44 Query performance discontinuity