On 22 March 2013 02:14, Tom Lane <t...@sss.pgh.pa.us> wrote: > Simon Riggs <si...@2ndquadrant.com> writes: >> Only one setting will be best for the whole cluster, so neither the >> user nor the DBA gains if a user sets this to a different value than >> the one that has been determined to be optimal. > >> Since we wait while holding the lock it is actually harmful to >> everyone if anybody sets a stupid value and might even be considered a >> denial of service attack. > >> So there is a very good reason to make this SIGHUP, not just a whim. > > Hmm. If a malicious user could hurt performance for other sessions with > a bad setting of commit_delay, then USERSET is clearly a bad idea. > But it still seems like it could be SUSET rather than SIGHUP.
Agreed; everybody gets what they want. Committed. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers