# HG changeset patch # User Philippe Pepiot # Date 1585575002 -7200 # Node ID 01810941a4be923e8331976998884124c9a7cf4d # Parent 2c3a8a4f5a021198c8577aa5aef594ce23b75e69 [server] use a LifoQueue in _CnxSetPool In postgresql, some cache is attached to the connection. Using a LifoQueue (last-in, first-out) makes a few connections to get the most load which give best performance. diff -r 2c3a8a4f5a02 -r 01810941a4be cubicweb/server/repository.py --- a/cubicweb/server/repository.py Mon Mar 30 15:23:56 2020 +0200 +++ b/cubicweb/server/repository.py Mon Mar 30 15:30:02 2020 +0200 @@ -173,7 +173,7 @@ def __init__(self, source, size): super().__init__(source) self._cnxsets = [] - self._queue = queue.Queue() + self._queue = queue.LifoQueue() for i in range(size): self._queue.put_nowait(self._new_cnxset())