On Tue, Oct 18, 2016 at 4:08 PM, Rahila Syed <rahilasye...@gmail.com> wrote: >>Another point which needs some thoughts is whether it is good idea to >>use index relation size to calculate parallel workers for index scan. >>I think ideally for index scans it should be based on number of pages >>to be fetched/scanned from index. > IIUC, its not possible to know the exact number of pages scanned from an > index > in advance.
We can't find the exact numbers of index pages to be scanned, but I think we can find estimated number of pages to be fetched (refer cost_index). -- With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers