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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, 7 Apr 2010, Sherry.CTR.Zhu@xxxxxxx wrote:
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.

Have you tried it?

Grzegorz Jaśkiewicz <gryzman@xxxxxxxxx> wrote:
something like this:   create index idx1 on tb1(col1, col2);
yup :)

For those of you who are not native English speakers, "Yup" is a synonym for "Yes."

Matthew

--
Richards' Laws of Data Security:
1. Don't buy a computer.
2. If you must buy a computer, don't turn it on.
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux