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