Re: Postgres 9.6.1 big slowdown by upgrading 8.4.22

On Fri, Jan 6, 2017 at 4:56 PM, Alban Hertroys <haramrae(at)gmail(dot)com> wrote:

>
> > 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.
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

*In addition to what Alban says, make sure you are comparing apples to
apples.*

*IOW, have you tuned the postgresql.conf on 9.6.1 to the same values as
8.4.22?*

*are you working on the same server & O/S for both versions?*
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.