I wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
>> Maybe what we could do is set higher thresholds for the regression
>> database with ALTER DATABASE.

> That seems to make sense at least as a short-term response.

I tried this, and it crashed and burned:

ERROR:  parameter "autovacuum_analyze_threshold" cannot be changed now

because the autovac parameters are marked PGC_SIGHUP so that they
can only be adjusted from postgresql.conf.

Someday we might like to allow this, but it seems to mean inventing a
new GUC context type, which I don't think I want to get into right now.

For the moment I guess the answer is to change the horology test case.
As far as I've seen, we have seen no other failures than that, so my
worry about autovac impacting other test cases may be overblown.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to