[HACKERS] Checking a heap page

2005-11-28 Thread Bruce Momjian 
With the applied patch that checks an entire heap page with one lock, is
there any advantage of considering this for index pages?

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  pgman@candle.pha.pa.us   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match

Re: [HACKERS] Checking a heap page

2005-11-28 Thread Tom Lane 
Bruce Momjian pgman@candle.pha.pa.us writes:
 With the applied patch that checks an entire heap page with one lock, is
 there any advantage of considering this for index pages?

Done already (see bitmap index scans).

regards, tom lane

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq