3 ms·

> rely on automated query optimization and parallelization from there. I know you said "automated parallelization" but... in newer versions of Postgres, what d

• 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 ago
    Does 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 ago
      Postgres uses separate processes under the hood and thus shared memory to combine results.