Em 06-11-2012 17:24, Tom Lane escreveu:
Rodrigo Rosenfeld Rosas<rr.rosas@xxxxxxxxx> writes:
Em 06-11-2012 16:42, Merlin Moncure escreveu:
Hm -- looking at your 'slow' 9.2 query, it is reporting that the query
took 3 seconds (reported times are in milliseconds). How are you
timing the data? What happens when you run explain analyze
<your_query> from psql (as in, how long does it take)?
The time I reported in the tables of my first message were the time
reported by pgAdmin3 (compiled from source).
But I get similar time when I run like this:
time psql -p 5432 -f slow.sql db_name> slow-9.2-again.explain
real 1m56.353s
user 0m0.068s
sys 0m0.020s
slow-9.2-again.explain: http://explain.depesz.com/s/zF1
But that again shows only five seconds runtime. If you repeat the query
several dozen times in a row, run the same way each time, do you get
consistent timings?
Yes, the timings are consistent here.
Can you put together a self-contained test case to duplicate these
results? I'm prepared to believe there's some sort of planner
regression involved here, but we'll never find it without a test case.
I'd love to, but I'm afraid I won't have time to do this any time soon.
Maybe on Sunday. I'll see if I can get a script to generate the database
on Sunday and hope for it to replicate the issue.
Would you mind if I coded it using Ruby? (can you run Ruby code in your
computer?) I mean, for filling with some sample data.
Right now I need to concentrate on getting a working solution for 9.1
and downgrade the database and work in several other requested fixes.
That is why I'm out of time for writing this test case right now... I'll
try to find some time on Sunday and will post here if I can replicate.
Thank you so much!
Rodrigo.
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
