X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 0AC8511F6603 for ; Sat, 22 Apr 2006 18:34:24 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.55 X-Spam-Level: X-Spam-Status: No, score=0.55 required=5 tests=[NO_REAL_NAME=0.55] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id SwzWsQ8aamN3 for ; Sat, 22 Apr 2006 18:34:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 2FD1711F6609 for ; Sat, 22 Apr 2006 18:34:21 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id B1508314B3; Sat, 22 Apr 2006 23:34:19 +0200 (MET DST) From: clemens.bertschler@gmail.com X-Newsgroups: pgsql.performance Subject: Easy question Date: 22 Apr 2006 14:34:13 -0700 Organization: http://groups.google.com Lines: 16 Message-ID: <1145741653.759727.38970@e56g2000cwe.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Complaints-To: groups-abuse@google.com User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.2) Gecko/20060308 Firefox/1.5.0.2,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: e56g2000cwe.googlegroups.com; posting-host=200.114.70.217; posting-account=I3Q4Kw0AAAB5qSAosGYN-4vsrNRUrVAS To: pgsql-performance@postgresql.org X-Archive-Number: 200604/540 X-Sequence-Number: 18624 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