0002147: PostgreSQL Optimisation - SOGo

ID	Project	Category	View Status	Date Submitted	Last Update

0002147	SOGo	Backend General	public	2012-12-16 22:25	2012-12-16 22:25

Reporter	geepie	Assigned To
Priority	normal	Severity	feature	Reproducibility	always
Status	new	Resolution	open
Product Version	2.0.3a

Summary	0002147: PostgreSQL Optimisation
Description	Default parameter on postgresql connexion should be pushed in the user definition.
Additional Information	From the detailled log of postgresql: Dec 16 23:17:35 desktop postgres[2887]: [10-1] u=_sogo,db=mail LOG: statement: SET standard_conforming_strings TO 'on' Dec 16 23:17:35 desktop postgres[2887]: [11-1] u=_sogo,db=mail LOG: statement: set client_encoding to 'UTF8' These Two statements should be deleted and replace by ALTER USER _sogo SET standard_conforming_strings TO 'on'; ALTER USER _sogo SET client_encoding to 'UTF8'; => Less flow between sogo and postgresql.
Tags	No tags attached.

Date Modified	Username	Field	Change
2012-12-16 22:25	geepie	New Issue