Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Slow query with backwards index scan
- From: andrew(at)pillette(dot)com
- To: Tilmann Singer <tils-pgsql(at)tils(dot)net>
- Cc: andrew(at)pillette(dot)com, pgsql-performance(at)postgresql(dot)org
- Subject: Re: Slow query with backwards index scan
- Date: Sat, 28 Jul 2007 13:43:58 -0700
As other posters have pointed out, you can overcome the ORDER BY/LIMIT restriction on UNIONs with parentheses. I think I misbalanced the parentheses in my original post, which would have caused an error if you just copied and pasted. I don't think the limitation has to do with planning--just parsing the query.
- Prev by Date: RES: select on 1milion register = 6s
- Next by Date: Re: Slow query with backwards index scan
- Previous by thread: Re: Slow query with backwards index scan
- Next by thread: Vacuum looping?
- Indexes: