Wed Feb 2 03:58:21 PST 2011
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
http://www.slony.info/bugzilla/show_bug.cgi?id=195 Summary: Improve slony performance with function volatility Product: Slony-I Version: 1.2 Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: low Component: stored procedures AssignedTo: slony1-bugs at lists.slony.info ReportedBy: tkarlik at ultimo.pl CC: slony1-bugs at lists.slony.info Estimated Hours: 0.0 Created an attachment (id=87) --> (http://www.slony.info/bugzilla/attachment.cgi?id=87) Query execution plans Overall performance can be increased by changing volatility of functions: - slon_quote_input, - slon_quote_brute to 'immutable'. It's especially related to databases with many tables. Real query execution example is attached. -- Configure bugmail: http://www.slony.info/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug. You are the assignee for the bug.
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-bugs mailing list