Parallel Btree index scan
Started by Krithika Venkateshabout 8 years ago2 messagesgeneral
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
Import Notes
Reply to msg id not found: CAP7eca2+F_6tSROY-w0A6xofU9d6iks1EYFA4qju+Qo0UoPgxA@mail.gmail.comReference msg id not found: CAP7eca3Lqa7+xvnk2Cv5XmZkr6e8K36EhsUpqfHwfhui_epAZA@mail.gmail.comReference msg id not found: CAP7eca2OFmjBxCxcOSEUBs7seZDidkPq2ukrREcAohGJOGiAcg@mail.gmail.comReference msg id not found: CAP7eca3dKhmx9+oY6b=uzDSjGm6_8skfTCLvwDuMR5d5DsEo-w@mail.gmail.comReference msg id not found: CAP7eca0DfhU1eLHHTP1BBWCwmxTMhq-ktFQBy9+FLFBwkL3ESw@mail.gmail.comReference msg id not found: CAP7eca2+F_6tSROY-w0A6xofU9d6iks1EYFA4qju+Qo0UoPgxA@mail.gmail.com
Re: Parallel Btree index scan
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 satisfied by index without bothering to go into data pages. For eg: select count(*) from table where col1 = 123. Assuming col1
is indexed, there is no need to visit data blocks.