[server] Make connection pooler configurable and set better default values
Drop the configuration connections-pool-size and add new configurations options:
* connections-pool-min-size. Set to 0 by default so we open connections only
when needed. This avoid opening min-size*processes connections at startup,
which is, it think, a good default.
* connections-pool-max-size. Set to 0 (unlimited) by default, so we move the
bottleneck to postgresql.
* connections-idle-timeout. Set to 10 minutes. I don't have arguments about
this except that this is the default in pgbouncer.
from yams.buildobjs import (EntityType, RelationType, SubjectRelation,
RichString)
from cubicweb.schema import RRQLExpression
class Comment(EntityType):
"""a comment is a reply about another entity"""
__permissions__ = {
'read': ('managers', 'users', 'guests',),
'add': ('managers', 'users',),
'delete': ('managers', 'owners',),
'update': ('managers', 'owners',),
}
content = RichString(required=True, fulltextindexed=True)
comments = SubjectRelation('Comment', cardinality='1*', composite='object')
class comments(RelationType):
__permissions__ = {
'read': ('managers', 'users', 'guests'),
'add': ('managers', 'users',),
'delete': ('managers', RRQLExpression('S owned_by U'),),
}
inlined = True
composite = 'object'
cardinality = '1*'