Re: Sorting performance vs. MySQL

From: Yeb Havinga <yebhavinga(at)gmail(dot)com>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Yang Zhang <yanghatespam(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Sorting performance vs. MySQL
Date: 2010-02-23 09:48:14
Message-ID: 4B83A45E.1080701@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greg Stark wrote:
>
> You can do \set FETCH_COUNT to have psql use a cursor automatically.
>
It seems like a big win in this case. What would be the downside of
having a fetch_count set default in psql?

regards
Yeb Havinga

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Net Tree Inc. 2010-02-23 09:50:46 pg_dump: aborting because of version mismatch
Previous Message Oliver Kohll - Mailing Lists 2010-02-23 09:45:05 pg_dump new version