bugzilla-daemon at main.slony.info bugzilla-daemon at main.slony.info
Wed Feb 2 03:58:21 PST 2011
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.


More information about the Slony1-bugs mailing list