Search Postgresql Archives

Re: Postgres 9.6.1 big slowdown by upgrading 8.4.22

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux