| From: | Denes Daniel <panther-d(at)freemail(dot)hu> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Query planner unaware of possibly best plan |
| Date: | 2007-09-21 20:05:29 |
| Message-ID: | freemail.20070821220529.11365@fm03.freemail.hu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
In reply to Alvaro Herrera:
> The best thing to do is paste them in a text file and send it as an
> attachment.
Okay, it's attached.
> Why did you set enable_sort=off? It's not like sorting 9 rows is going
> to take any noticeable amount of time anyway.
Of course it's no problem for 9 rows, but this is only a test case. In
production there will be much more. I just wanted to show that the
planner doesn't even consider a plan without a sort step, using purely
index scans.
Denes Daniel
------------------------------------------------------------
Olvasd az [origo]-t a mobilodon: mini magazinok a Mobizin-en
___________________________________________________
www.t-mobile.hu/mobizin
| Attachment | Content-Type | Size |
|---|---|---|
| expana.txt | text/plain | 1001 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luiz K. Matsumura | 2007-09-21 20:40:52 | Re: Low CPU Usage |
| Previous Message | Alvaro Herrera | 2007-09-21 19:56:44 | Re: Query planner unaware of possibly best plan |