| From: | Greg Stark <gsstark(at)mit(dot)edu> |
|---|---|
| To: | Yeb Havinga <yebhavinga(at)gmail(dot)com> |
| 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 10:17:01 |
| Message-ID: | 407d949e1002230217u43d55ccg9e07f0014532da44@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Feb 23, 2010 at 9:48 AM, Yeb Havinga <yebhavinga(at)gmail(dot)com> wrote:
> 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?
They were mentioned previously in this thread:
1) If an error occurs partway through the execution of the query you
might receive part of the result set.
2) psql won't be able to align the columns properly
--
greg
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2010-02-23 10:21:18 | Re: Implementing an Index Access Method in PG 8.4 |
| Previous Message | Carsten Kropf | 2010-02-23 10:00:46 | Implementing an Index Access Method in PG 8.4 |