Re: Parallel Index Scans
Amit Kapila <amit.kapila16@gmail.com>
From: Amit Kapila <amit.kapila16@gmail.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Anastasia Lubennikova <a.lubennikova@postgrespro.ru>, Anastasia Lubennikova <lubennikovaav@gmail.com>,
pgsql-hackers <pgsql-hackers@postgresql.org>, Rahila Syed <rahilasyed.90@gmail.com>
Date: 2017-01-23T06:03:56Z
Lists: pgsql-hackers
Attachments
- parallel-generic-index-scan.2.patch (application/octet-stream) patch
- parallel_index_scan_v6.patch (application/octet-stream) patch v6
- parallel_index_opt_exec_support_v6.patch (application/octet-stream) patch v6
- (unnamed) (text/plain)
On Sat, Jan 21, 2017 at 12:23 PM, Amit Kapila <amit.kapila16@gmail.com> wrote: > On Sat, Jan 21, 2017 at 1:15 AM, Robert Haas <robertmhaas@gmail.com> wrote: >> >> I think it's a good idea to put all three of those functions together >> in the listing, similar to what we did in >> 69d34408e5e7adcef8ef2f4e9c4f2919637e9a06 for FDWs. After all they are >> closely related in purpose, and it may be easiest to understand if >> they are next to each other in the listing. I suggest that we move >> them to the end in IndexAmRoutine similar to the way FdwRoutine was >> done; in other words, my idea is to make the structure consistent with >> the way that I revised the documentation instead of making the >> documentation consistent with the order you picked for the structure >> members. What I like about that is that it gives a good opportunity >> to include some general remarks on parallel index scans in a central >> place, as I did in that patch. Also, it makes it easier for people >> who care about parallel index scans to find all of the related things >> (since they are together) and for people who don't care about them to >> ignore it all (for the same reason). What do you think about that >> approach? >> > > Sounds sensible. Updated patch based on that approach is attached. > In spite of being careful, I missed reorganizing the functions in genam.h which I have done in attached patch. > I > will rebase the remaining work based on this patch and send them > separately. > Rebased patches are attached. I have fixed few review comments in these patches. parallel_index_scan_v6 - Changed the function btparallelrescan so that it always expects a valid parallel scan descriptor. parallel_index_opt_exec_support_v6 - Removed the usage of GatherSupportsBackwardScan. Expanded the comments in ExecReScanIndexScan. -- With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com
Commits
-
Replace min_parallel_relation_size with two new GUCs.
- 51ee6f3160d2 10.0 landed
-
Factor out logic for computing number of parallel workers.
- 716c7d4b242f 10.0 cited
-
Support condition variables.
- e8ac886c2477 10.0 cited
-
Allow parallel custom and foreign scans.
- 69d34408e5e7 9.6.0 cited
-
Add a C API for parallel heap scans.
- ee7ca559fcf4 9.6.0 cited