Re: Extra cost of "lossy mode" Bitmap Scan plan - Mailing list pgsql-hackers

From higepon
Subject Re: Extra cost of "lossy mode" Bitmap Scan plan
Date
Msg-id f07386410905080043u3b59bfd9q540d6796b9f84c17@mail.gmail.com
Whole thread Raw
In response to Re: Extra cost of "lossy mode" Bitmap Scan plan  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.


pgsql-hackers by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Serializable Isolation without blocking
Next
From: higepon
Date:
Subject: WAL dump tool