Thank you all for your replies.
I did figure out what is going on.
9.1 is indeed faster than 8.2.11 so we are good to go forward.
Thank you again
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Slower-Performance-on-Postgres-9-1-6-vs-8-2-11-tp5729749p5729991.html
Sen
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 t
Sorry,
Again, I'm really new and so don't know how I would go about getting results
from "contrib/pg_test_timing"
Is this something that can be done from psql prompt, or will I need my
developers to get involved and write me something...?
Sorry for being such a newbie:)
--
View this messa
All... first let me say thank you for this forum I am new to it and
relatively new to postgres, more of a sysadmin than a DBA, but let me
explain my issue. I'll try also to post relevant information as well.
Our IT group took over an app that we have running using postgres and it has
been on
