Right but R is only "preloaded" once?
Yes. The plr shared library gets loaded and initialized (which in turn loads and initializes libR) only once -- on Postgres's postmaster startup. From that point forward, every new database connection gets a forked copy of the postmaster, and hence a preinitialized copy of the R interpreter.
Of course (as I think I mentioned already, but it is worth repeating) to get this performance enhancement you need to be using either Postgres 7.4 beta or a patched version of Postgres 7.3 (found at the URL on the original post), and have the following line in your postgresql.conf:
preload_libraries = '$libdir/plr:plr_init'
This is getting a bit off topic, so if you have any more PL/R specific questions, please write me off list.
Joe
______________________________________________ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help
