Re: Parallel Btree index scan

2018-01-17 Thread Rakesh Kumar
> And what is the difference between index scan and index only scan. Index scan: Index lookup for key access plus read from data blocks to satisfy the query. Index only scan: Index lookup for key access plus read from index pages itself to satisfy query. In other words, entire query can be

Parallel Btree index scan

2018-01-16 Thread Krithika Venkatesh
Hi All, Can you please help me to understand what is parallel btree index scan in Postgres 10. And what is the difference between index scan and index only scan. Thanks, Krithika