A bit late to respond but better than never!
As of my latest testing in 8.3, I've found that the lo_* functions while adequate are a bit slow. Our implemented alternative that leverages pg_read_file() is significantly faster. I believe it is because pg_read_file() tells the database to go straight to the file system rather than through the client connection. From memory, I seem to recall this being about 20% faster than the lo_* option or simple INSERTs.
The downside to pg_read_file() is that the file must be 1) on the same system as the database and 2) must be under the $PGDATA directory. We opted to create a directory $PGDATA/public with proper system-side permissions but open enough to allow the database owner to read the files.
For example,
postgres=# select pg_read_file('public/a_file', 0, (pg_stat_file('postgresql.conf')).size);
We use this method in conjunction with additional checks to store files in tables governed by the MD5 hash of the file to prevent duplication.
HTH.
Greg
