[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.

     1

for eschema in schema.entities():

     2

    if not (eschema.final or 'cw_source' in eschema.subjrels):

     3

        add_relation_definition(eschema.type, 'cw_source', 'CWSource', ask_confirm=False)

     4

     5

sql('INSERT INTO cw_source_relation(eid_from, eid_to) '

     6

    'SELECT e.eid,s.cw_eid FROM entities as e, cw_CWSource as s '

     7

    'WHERE s.cw_name=e.source AND NOT EXISTS(SELECT 1 FROM cw_source_relation WHERE eid_from=e.eid AND eid_to=s.cw_eid)')

     8

commit()