Re: Query planner unaware of possibly best plan - Mailing list pgsql-performance

From Denes Daniel
Subject Re: Query planner unaware of possibly best plan
Date
Msg-id freemail.20070821220529.11365@fm03.freemail.hu
Whole thread Raw
In response to Re: Query planner unaware of possibly best plan  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Query planner unaware of possibly best plan
Next
From: "Luiz K. Matsumura"
Date:
Subject: Re: Low CPU Usage