-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > It remains unclear to me why the same DBI/DBD::Pg client code > would deliver performance 2-3 orders of magnitude better on > other roughly comparable or inferior boxes. You need to see exactly what is going on to make things so slow. You can try setting the trace level for very verbose detail (e.g. $dbh->trace(10)) or you could look at using DBI::Profile or DBI::ProfileDumper. If it is the same code and same databases on different boxes, there is definitely something weird going on. Make sure that Perl, DBI, DBD::Pg, Postgres, and the Postgres libraries are all the same version. Running "make test" for DBD::Pg will display the current settings for all of the above. (or just copy the code from t/01connect.t). If all versions are indeed the same, see if you can create a small test script that illustrates the problem, then run the above mentioned debugging aids and see if you can spot a difference. - -- Greg Sabino Mullane greg@xxxxxxxxxxxx PGP Key: 0x14964AC8 200508120941 https://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEARECAAYFAkL8p0oACgkQvJuQZxSWSsjlowCeOS6GkhISN4d6oWaRQQfD91QA Eg8AoPJz55hEwmOcuuHC7GpLMf0cDstt =ZZME -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
