Performance

From: "Bert" <clemens(dot)bertschler(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Performance
Date: 2006-04-22 23:18:32
Message-ID: 1145747912.180559.47990@i40g2000cwc.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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-general by date

  From Date Subject
Next Message John Oliver 2006-04-22 23:57:16 Problems logging in
Previous Message Tom Lane 2006-04-22 19:10:58 Re: Automatically assuming a specific role after connecting to pg