Re: Slower Performance on Postgres 9.1.6 vs 8.2.11

Hello

2012/10/26 robcron <rocron(at)pssd(dot)com>:
> Okay, so I took EXPLAIN ANALYZE off and made sure that timing is on "psql"
> command \timing shows
>
> Timing = on
>
> Run the query several times..
>
> 9.1.6 runs this query an average of 354 ms
> 8.2.11 runs this query an average of 437 ms
>
> So 9.1 IS FASTER
>
> Why is EXPLAIN ANALYZE showing the reverse...of that...?
>
> Evidently, since I fixed the database Collation ( set to a value of "C") it
> has been faster but I got locked into looking at the EXPLAIN ANALYZE
> results...
>
> MMMM very curious.

9.1 EXPLAIN ANALYZE collect significantly more information about
execution - so there can be higher overhead

Regards

Pavel

>
> Rob
>
>
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/Slower-Performance-on-Postgres-9-1-6-vs-8-2-11-tp5729749p5729768.html
> Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance