Hello 2012/10/26 robcron <rocron@xxxxxxxx>: > 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
