type of index?
От | Neil Conway |
---|---|
Тема | type of index? |
Дата | |
Msg-id | 20001204212903.C1186@klamath.dyndns.org обсуждение исходный текст |
Ответы |
Re: type of index?
|
Список | pgsql-general |
I'm wondering about the types of indexes available. I have an indexed column in a table which will ONLY be used with the '=' operator - in other words: SELECT foo FROM bar WHERE this_col = 1234; Should the index on this_col be a btree or a hash index? By default, it seems like Postgres is creating a btree index. But according to the PgSQL docs, a hash index could also be used. Which would result in better performance? Also, I've read in the list archives that btree indexes are much better, in general, than the others. Given this, which index is the best? Is there some of rule of thumb I can use to decide for this and other cases? Thanks in advance, Neil -- Neil Conway <neilconway@home.com> Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc Encrypted mail welcomed In every country and every age, the priest has been hostile to liberty. He is always in alliance with the despot ... they have perverted the purest religion ever preached to man into mystery and jargon, unintelligible to all mankind, and therfore the safer engine for their purpose. -- Thomas Jefferson
В списке pgsql-general по дате отправления: