Postgres Pro
Downloads
Home   >   mailing lists

Performance - Mailing list pgsql-general

From Bert
Subject Performance
Date
Msg-id 1145747912.180559.47990@i40g2000cwc.googlegroups.com
Whole thread Raw
Responses Re: Performance  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-general
Tree view 
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-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Automatically assuming a specific role after connecting to pg
Next
From: John Oliver
Date:
Subject: Problems logging in