Re: Postgres 11.0 Partitioned Table Query Performance

2018-11-07 Thread David Rowley
On 8 November 2018 at 15:28, Paul Schaap wrote: > I have an issue, and a partial workaround, with a query outlined below. What > I am hoping to get to is a Parallel Index Only Scan on my partition indexes > as theoretically that should be the fastest, but can only get either a > Parallel Seq Scan

Postgres 11.0 Partitioned Table Query Performance

2018-11-07 Thread Paul Schaap
Hi, I have an issue, and a partial workaround, with a query outlined below. What I am hoping to get to is a Parallel Index Only Scan on my partition indexes as theoretically that should be the fastest, but can only get either a Parallel Seq Scan on each partition which is very slow, or a non pa