Re: insert performance riddle

-----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(at)turnstep(dot)com
PGP Key: 0x14964AC8 200508120941
https://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iEYEARECAAYFAkL8p0oACgkQvJuQZxSWSsjlowCeOS6GkhISN4d6oWaRQQfD91QA
Eg8AoPJz55hEwmOcuuHC7GpLMf0cDstt
=ZZME
-----END PGP SIGNATURE-----