| From: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> |
|---|---|
| To: | "Zeugswetter Andreas SB" <ZeugswetterA(at)wien(dot)spardat(dot)at>, "'Tim Perdue'" <tperdue(at)valinux(dot)com> |
| Cc: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | RE: Some Improvement |
| Date: | 2000-07-13 07:45:57 |
| Message-ID: | 001801bfec9e$618d47a0$2801007e@tpf.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> -----Original Message-----
> From: pgsql-hackers-owner(at)hub(dot)org [mailto:pgsql-hackers-owner(at)hub(dot)org]On
> Behalf Of Zeugswetter Andreas SB
>
> > I still think there must be sorting going on, as the result
> > is returned
> > instantly if you remove the ORDER BY. I don't know - I do think it's
> > much better now.
>
> Are you doing the exact query I wrote for you ?
> That is:
> order by mail_list desc, mail_date desc
>
> explain should tell you if it does a sort. There should not be a
> difference
> with
> or without the order by.
> Hiroshi, I think you implemented the backwards index scan ?
Yes,but I didn't implement backwards index path for cost estimate.
Regards.
Hiroshi Inoue
Inoue(at)tpf(dot)co(dot)jp
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-07-13 07:56:19 | Re: Questions relating to "modified while in use" messages |
| Previous Message | Zeugswetter Andreas SB | 2000-07-13 07:45:04 | AW: lztext and compression ratios... |