On Fri, Aug 12, 2005 at 06:20:27PM -0600, Ed L. wrote: > 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. I meant profiling of DBD::Pg, as Greg Sabino Mullane suggested. Here's his message in case you missed it: http://archives.postgresql.org/pgsql-general/2005-08/msg00655.php -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings