On Tue, Oct 18, 2016 at 4:08 PM, Rahila Syed <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
