Re: Extra cost of "lossy mode" Bitmap Scan plan

From: higepon <higepon(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Extra cost of "lossy mode" Bitmap Scan plan
Date: 2009-05-08 07:43:59
Message-ID: f07386410905080043u3b59bfd9q540d6796b9f84c17@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi.

> fashion --- for instance, each page is read only once.  Index scan will
> result in a random sequence of accesses to the heap.  (Of course, it
> might have some order if the index is well correlated with the heap
> order, but most of the time that's not true.)

Thank you. I finally understand the difference.

Cheers.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message higepon 2009-05-08 08:43:11 WAL dump tool
Previous Message Albe Laurenz 2009-05-08 06:18:11 Re: Serializable Isolation without blocking