Hello,
I had a question regarding using PostgreSQL as the
authorization database for Apache. Previously I was using Apache authentication module for MySQL v2.20
(mod_auth_mysql) and was wondering if there was
an equivalent module for use with PostgreSQL?
I must add I'm really impressed with the
responsiveness of the 7.0.3 PostgreSQL under decent load from my java
servers. Replacing my "left joins" with subselects and keeping the
temporary tables (you have to use them in mysql in a lot of cases), I see quite
a number of performance increases or about-the-same query times. I'm not a
benchmarking type of guy, just have a feel for "seems slower, seems faster,
seems-about-the-same". Very cool. Plus, the original reason I
switched (something very very strange with multiple threads pounding the JDBC
driver and/or transient temporary table collisions corrupting query constructs
and updates) seems all but last week's headache (fingers crossed).
Thanks,
George
|