Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Easy question
- From: clemens(dot)bertschler(at)gmail(dot)com
- To: pgsql-performance(at)postgresql(dot)org
- Subject: Easy question
- Date: 22 Apr 2006 14:34:13 -0700
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
- Follow-Ups:
- Re: Easy question
- From: codeWarrior
- Re: Easy question
- Prev by Date: Re: Introducing a new linux readahead framework
- Next by Date: Re: Recovery will take 10 hours
- Previous by thread: Re: WAL logging of SELECT ... INTO command
- Next by thread: Re: Easy question
- Indexes: