On Mon, 26 Dec 2005, Tom Lane wrote:
...snip...
Thanks, it's a very good explanation!
--
Preserve wildlife -- pickle a squirrel today!
---(end of broadcast)---
TIP 6: explain analyze is your friend
Ivan Voras <[EMAIL PROTECTED]> writes:
> This is PostgreSQL 8.1.0.
> - what does "Bitmap Heap Scan" phase do?
A plain indexscan fetches one tuple-pointer at a time from the index,
and immediately visits that tuple in the table. A bitmap scan fetches
all the tuple-pointers from the index in one g
Hi!
This is not actually a question about performance, but an inquiry to help
me understand what is going on. Below this text are two EXPLAIN ANALYZE
outputs, before and after VACUUM ANALYZE was run. I have several questions
about the proposed plans (mostly the first one). There is only one ta
