[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

from yams import register_base_type

     2

from logilab.database import get_db_helper

     3

     4

_NUMERIC_PARAMETERS = {'scale': 0, 'precision': None}

     5

register_base_type('Numeric', _NUMERIC_PARAMETERS)

     6

     7

# Add the datatype to the helper mapping

     8

pghelper = get_db_helper('postgres')

     9

    10

    11

def pg_numeric_sqltype(rdef):

    12

    """Return a PostgreSQL column type corresponding to rdef

    13

    """

    14

    return 'numeric(%s, %s)' % (rdef.precision, rdef.scale)

    15

    16

    17

pghelper.TYPE_MAPPING['Numeric'] = pg_numeric_sqltype