Re: Easy question

Поиск
Список
Период
Сортировка
От Bert
Тема Re: Easy question
Дата
Msg-id 1146355679.311472.57800@u72g2000cwu.googlegroups.com
обсуждение исходный текст
Ответ на Re: Easy question  ("Michael Artz" <mlartz@gmail.com>)
Ответы Re: Easy question
Список pgsql-performance
No i didn't defined any indexes for the table, I know the performance
will increase with an index, but this was not my question. My question
furthermore belongs to the access mode of the SQL statement.
Furthermore i do not understand why the Upper function should increase
the performance.
The table has approximately 20.000 entries.
Is it the best way to use a B-Tree index on the municipio column in
this case or are there better solution to do this.


В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Nested loop join and date range query
Следующее
От: Eric Lam
Дата:
Сообщение: Re: Slow restoration question