Easy question

Поиск
Список
Период
Сортировка
От clemens.bertschler@gmail.com
Тема Easy question
Дата
Msg-id 1145741653.759727.38970@e56g2000cwe.googlegroups.com
обсуждение исходный текст
Ответы Re: Easy question  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-performance
Hi List
I have maybe an easy question but i do not find an answer, i have this
SQL query:

SELECT geom,group,production_facs FROM south_america
        WHERE municipio = ''
            OR municipio = 'ACRE'
            OR municipio = 'ADJUNTAS'
            OR municipio = 'AGUADA'

The performance of this query is quite worse as longer it gets, its
possible that this query gets over 20 to 30 OR comparisons, but then
the performance is really worse, is it possible to speed it up?
Thanks
Clemens


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

Предыдущее
От: "Greg Stumph"
Дата:
Сообщение: Worsening performance with 7.4 on flash-based system
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: serious problems with vacuuming databases