On Friday August 12 2005 6:11 pm, Michael Fuhr wrote:
> Has anything changed on the system since the results were
> consistently slow? New hardware, new versions of anything,
> reboot, etc.? Did you do any profiling when DBD::Pg was
> consistently slow to see where the bottleneck was?
All good questions. Obviously, something has changed, but I'm
hard-pressed to identify what it might have been. No, I didn't
do any profiling, since I found the presumed dbi/libpq
difference first. I will measure perf of dbi, Pg, and libpq
over time and see if I can combine with I/O measures to see
trends.
Ed
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
