Postgres Pro
Downloads
Home   >   mailing lists

Easy question - Mailing list pgsql-performance

From clemens.bertschler@gmail.com
Subject Easy question
Date
Msg-id 1145741653.759727.38970@e56g2000cwe.googlegroups.com
Whole thread Raw
Responses Re: Easy question  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-performance
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-performance by date:

Previous
From: "Greg Stumph"
Date:
Subject: Worsening performance with 7.4 on flash-based system
Next
From: Tomas Vondra
Date:
Subject: Re: serious problems with vacuuming databases