Re: LIMIT causes planner to do Index Scan using a less optimal index

[Sherry.CTR.Zhu@xxxxxxx]

Please just let me know if Postgres
can do this kind of index or not.  

create index idx1 on tb1(col1, col2)

Then later we can find it is useful
or useless.  


Thanks much!

Xuefeng Zhu (Sherry)
Crown Consulting Inc. -- Oracle DBA
AIM Lab Data Team 
(703) 925-3192

Grzegorz Jaśkiewicz <gryzman@xxxxxxxxx>
Sent by: pgsql-performance-owner@xxxxxxxxxxxxxx

04/07/2010 09:12 AM

To	Sherry CTR Zhu/AWA/CNTR/FAA@FAA
cc	Joel Jacobson <joel@xxxxxxxxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxx, Robert Haas <robertmhaas@xxxxxxxxx>
Subject	Re: LIMIT causes planner to do Index Scan using a less         optimal index

2010/4/7 <Sherry.CTR.Zhu@xxxxxxx>

Do you mean one index on two columns? 

something like this:   create index idx1 on tb1(col1, col2);

yup :) It would be quite useless without that feature.
Don't listen to oracle folks, they obviously know not much about products
others than oracle db(s). 
 




-- 
GJ