Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Old-style OR indexscan slated for destruction
- From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
- To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: pgsql-hackers(at)postgresql(dot)org
- Subject: Re: Old-style OR indexscan slated for destruction
- Date: Mon, 25 Apr 2005 00:45:23 +0400 (MSD)
- Message-id: <Pine(dot)GSO(dot)4(dot)62(dot)0504250044550(dot)4489(at)ra(dot)sai(dot)msu(dot)su>
On Sun, 24 Apr 2005, Tom Lane wrote:
I am about to rip out the code that supports multiple indexscans for OR conditions inside a single IndexScan plan node. As best I can tell, the new-style bitmap-OR code is as fast or faster than the old way even in fully cached test cases (ie, with no allowance for improved efficiency of disk access). So there's no percentage in maintaining support for the old way, and getting rid of it will allow simplification of code and data structures in the planner.
very good, Tom !
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
- Follow-Ups:
- Re: Old-style OR indexscan slated for destruction
- From: Christopher Kings-Lynne
- Re: Old-style OR indexscan slated for destruction
- References:
- Old-style OR indexscan slated for destruction
- From: Tom Lane
- Old-style OR indexscan slated for destruction
- Prev by Date: Re: [pgsql-hackers-win32] UNICODE/UTF-8 on win32
- Next by Date: CVS regression test problem
- Previous by thread: Old-style OR indexscan slated for destruction
- Next by thread: Re: Old-style OR indexscan slated for destruction
- Indexes: