Changes between Initial Version and Version 1 of InstallationGuidelines/PostgreSQL

Timestamp:

02/16/09 07:59:04 (16 years ago)

Author:

Fran Boon

Comment:

--

InstallationGuidelines/PostgreSQL

@@ +1 @@
+== Installation on PostgreSQL ==
+Replacing the simple SQLite database with PostgreSQL allows greater scalability
+
+Suggest to use connection pools to reuse connections:
+{{{
+db=SQLDB('postgres://user:password@hostname/db',pools=20)
+}}}
+
+How many pools?
+{{{
+whatever you choose it always starts with one and grows with the
+number of concurrent requests up to the value of pools (the max number
+of concurrent pools). So pools should be the max number of concurrent
+requests you expect. That is the max value of:
+<number of requests/second> / <average time per request in seconcds> 
+}}}
+
+----
+InstallationGuidelines