Easy question

From: clemens(dot)bertschler(at)gmail(dot)com
To: pgsql-performance(at)postgresql(dot)org
Subject: Easy question
Date: 2006-04-22 21:34:13
Message-ID: 1145741653.759727.38970@e56g2000cwe.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Simon Riggs 2006-04-23 16:06:07 Re: Recovery will take 10 hours
Previous Message Wu Fengguang 2006-04-22 12:15:26 Re: Introducing a new linux readahead framework