Re: Bad planner performance for tables with empty tuples when using JIT

2020-10-27 Thread Michael Lewis
On Tue, Oct 27, 2020 at 6:14 AM Jurrie Overgoor < postgresql-mailingl...@jurr.org> wrote: > - I could turn off JIT in the server config, but I'd like to use the JIT feature where it's appropriate! I would do this, until PG14 and you can verify it works in most cases for you. 9.6 to 13 is alread

Bad planner performance for tables with empty tuples when using JIT

2020-10-27 Thread Jurrie Overgoor
Hello everyone, I'm currently in the process of upgrading our PostgreSQL installations from 9.6 to 13. I am experiencing very slow query performance for empty tables. Our test environments get build from scratch every run, and thus contain a lot of empty tables at first. We hit the issue dis