pá 6. 12. 2019 v 15:12 odesílatel Mladen Marinović <
mladen.marino...@kset.org> napsal:
> After a couple of hours of trying different stuff, set enable_mergejoin =
> off made the planning time look better: Planning time: 0.322 ms
> Any ideas why this helps?
>
pls, can you try reindex all related
On Fri, Dec 6, 2019, 3:21 AM Mladen Marinović
wrote:
> Is there a way to detect why the planing is taking this long?
>
> The database is a 9.6.1 with 32GB of shared_buffers, and 1GB of
> maintanance_work_mem, and machine CPU is below 80% all the time.
>
What is default_statistics_target set to f
=?UTF-8?Q?Mladen_Marinovi=C4=87?= writes:
> After a couple of hours of trying different stuff, set enable_mergejoin =
> off made the planning time look better: Planning time: 0.322 ms
> Any ideas why this helps?
Hmm, possibly because it's reducing the number of calls to
get_actual_variable_range
After a couple of hours of trying different stuff, set enable_mergejoin =
off made the planning time look better: Planning time: 0.322 ms
Any ideas why this helps?
Regards,
Mladen Marinović
On Fri, Dec 6, 2019 at 11:14 AM Mladen Marinović
wrote:
> Hi,
>
> Since this morning our system is runni
