[Lxr-general] Large installations running on Postgres?

[Malcolm B. <mal...@gm...>]

Hi,

I'm wondering what the performance (dis)advantage is of having
DBI::AutoCommit switched off for Postgresql.  As part of a general
tidy-up of the Index classes I'm considering switching AutoCommit to
on - but I don't have a decent-sized install to check the performance
impact.

Has anyone got a large-ish installation running using Postgres who
could measure the performance with AutoCommit switched on and off -
the relevant line to change is line 43 in lib/LXR/Index/Postgres.pm.

Any data would be much appreciated!

Cheers,

Malcolm