2 ms·
> what does it take to trigger some of the automatic query parallelization Table scans, index scans (b-tree & bitmap only I believe), joins, and aggregations.
by tomnipotent 6y ago
> what does it take to trigger some of the automatic query parallelization
Table scans, index scans (b-tree & bitmap only I believe), joins, and aggregations. There may be some limitations with joins, such as hash joins duplicating hashes across processes or merges requiring separate sorts.
- Frost1x 6y agoDoes this work outside of a shared memory environments? I haven't had to fuss with postgres for several years but last time I used it, this was non-trivial.
- tomnipotent 6y agoPostgres uses separate processes under the hood and thus shared memory to combine results.