Edgewall Software

Opened 13 years ago

Last modified 6 years ago

#8058 new enhancement

Smarter db connection pool

Reported by: Jonas Borgström Owned by:
Priority: lowest Milestone: next-major-releases
Component: general Version:
Severity: normal Keywords: performance, schema, postgresql
Cc: leho@… Branch:
Release Notes:
API Changes:
Internal Changes:


The current connection pool uses the entire connection string suitable connections to reuse.

This isn't very efficient when a single postgresql database contains multiple envs in separate schemas. In this case connections from different environments are reusable as long as the schema search_path is re-set.

Attachments (0)

Change History (4)

comment:1 by Christian Boos, 12 years ago

Keywords: performance postgres schema added
Milestone: next-minor-0.12.xnext-major-0.1X
Priority: normallowest

PatchWelcome, Jonas ;-)

comment:2 by lkraav <leho@…>, 10 years ago

Cc: leho@… added

comment:3 by Ryan J Ollos, 7 years ago

Keywords: postgresql added; postgres removed

comment:4 by Ryan J Ollos, 7 years ago

Owner: Jonas Borgström removed

Modify Ticket

Change Properties
Set your email in Preferences
as new The ticket will remain with no owner.
The ticket will be disowned.
as The resolution will be set. Next status will be 'closed'.
The owner will be changed from (none) to anonymous. Next status will be 'assigned'.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.