Changes between Initial Version and Version 1 of InstallationGuidelines/PostgreSQL


Ignore:
Timestamp:
02/16/09 07:59:04 (13 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • InstallationGuidelines/PostgreSQL

    v1 v1  
     1== Installation on PostgreSQL ==
     2Replacing the simple SQLite database with PostgreSQL allows greater scalability
     3
     4Suggest to use connection pools to reuse connections:
     5{{{
     6db=SQLDB('postgres://user:password@hostname/db',pools=20)
     7}}}
     8
     9How many pools?
     10{{{
     11whatever you choose it always starts with one and grows with the
     12number of concurrent requests up to the value of pools (the max number
     13of concurrent pools). So pools should be the max number of concurrent
     14requests you expect. That is the max value of:
     15<number of requests/second> / <average time per request in seconcds>
     16}}}
     17
     18----
     19InstallationGuidelines