Re: Postgres 9.6.1 big slowdown by upgrading 8.4.22

From: Alban Hertroys <haramrae(at)gmail(dot)com>
To: Job <Job(at)colliniconsulting(dot)it>
Cc: Rob Sargent <robjsargent(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres 9.6.1 big slowdown by upgrading 8.4.22
Date: 2017-01-06 21:56:09
Message-ID: C7EAAE1E-97E6-49DC-B829-3D384C79245D@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> On 6 Jan 2017, at 16:56, Job <Job(at)colliniconsulting(dot)it> wrote:
>
> W e use a function, the explain analyze is quite similar:
> POSTGRESQL 8.4.22:
> Total runtime: 1.531 ms
>
> POSTGRES 9.6.1:
> Execution time: 4.230 ms

Are you being serious? You're complaining about a "big slowdown" for a query that goes from 1.5ms to 4ms?
What is the actual problem you're trying to solve? Because I don't see one in the above.

Just saying, you're obviously worried about something, but should you be?

Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2017-01-06 23:47:15 Re: Postgres 9.6.1 big slowdown by upgrading 8.4.22
Previous Message Merlin Moncure 2017-01-06 20:34:26 Re: Queries on very big table