On 01/05/2017 10:18 AM, Job wrote:
> Hello guys,
> a very strange thing: after upgrading from 8.4.22 to 9.6.1 i noticed,
> under heavy beanchmarks, a really slowdown of Postgresql 9.6.1, with
> the machine really "without breath".
> By replacing Postgresql 8.4.22 evberything returns working fine.
> With three days of investigation, i come at a function with lots of
> joing and conditions.
> Only by removing this condition:
> "exists ( select 1 from gruorari where
> gruorari.idgrucate=grucategorie.id and ( (('{'||gg_sett||'}')::int[]
> && array[EXTRACT(DOW FROM NOW())::int])='t' and now()::time between
> gruorari.dalle::time and gruorari.alle::time) )"
> The benchmark with Postgresql 9.6.1 version are now very fast.
> The table metnioned by the query has got indexes:
> id | numeric(1000,1) | not null default function_get_next_sequence('gr
> uorari_id_seq'::text)
> idgrucate | numeric(1000,1) |
> dalle | character varying |
> alle | character varying |
> gg_sett | character varying |
> azione | character varying |
> Indexes:
> "keygruorari" PRIMARY KEY, btree (id)
> "alle_idx" btree (alle)
> "dalle_idx" btree (dalle)
> "gg_sett_idx" btree (gg_sett)
> "idgrucate_idx" btree (idgrucate)
> What is strange, is that with 8.4.22 version there is no problem, but
> there is something that does not deal with 9.6.1 version.
> Could you please help me?
>
> THANK YOU!
> /F
You might want to include the query plans for each server