Re: WAL Rate Limiting - Mailing list pgsql-hackers

From Tom Lane
Subject Re: WAL Rate Limiting
Date
Msg-id 27195.1389886520@sss.pgh.pa.us
Whole thread Raw
In response to Re: WAL Rate Limiting  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: WAL Rate Limiting  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
Andres Freund <andres@2ndquadrant.com> writes:
> I don't really see much difficulty in determining what's a utility
> command and what not for the purpose of this? All utility commands which
> create WAL in O(table_size) or worse.

By that definition, INSERT, UPDATE, and DELETE can all be "utility
commands".  So would a full-table-scan SELECT, if it's unfortunate
enough to run into a lot of hint-setting or HOT-pruning work.

I think possibly a more productive approach to this would be to treat
it as a session-level GUC setting, rather than hard-wiring it to affect
certain commands and not others.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Christian Kruse
Date:
Subject: Re: Why conf.d should be default, and auto.conf and recovery.conf should be in it
Next
From: Andres Freund
Date:
Subject: Re: WAL Rate Limiting