Very helpful thank you for the additional insight - I'd never checked into
pg_stats and that does reveal a difference in the distribution of the
validation_status_code between qa and production:
prod:
│ most_common_vals │ {P,F} │
│ most_common_freqs │ {0.925967,0.000933
Hi,
We're using PostgreSQL 9.6.3 on Linux.
I have a pl/pgsql stored procedure that is not utilizing the new
parallel sequential scan feature although manually running the same
query does (assuming the same settings/optimizer hints are used ofc).
A rough outline of the stored procedure (omittin
