From: codeWarrior <gpatnude@hotmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: Easy question
Date: Tue, 25 Apr 2006 08:55:29 -0700
Message-ID: <e2lgmr$1ii5$1@news.hub.org> (raw)
References: <1145741653.759727.38970@e56g2000cwe.googlegroups.com>
SELECT geom, group, production_facs FROM south_america
WHERE UPPER(municipio) IN ('ACRE', 'ADJUNTAS', 'AGUADA');
<clemens.bertschler@gmail.com> wrote in message
news:1145741653.759727.38970@e56g2000cwe.googlegroups.com...
> 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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gpatnude@hotmail.com
Subject: Re: Easy question
In-Reply-To: <e2lgmr$1ii5$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox