Tom Lane <[EMAIL PROTECTED]> wrote on 06-12-2005
16:07:41:
> That documentation is exactly correct. Note that it doesn't
say "can
> only be set at server start" full stop.
That's a very suttle difference, but you are right
of couse. It's the word 'only' that threw me off. In my mind, it should
Richard van den Berg <[EMAIL PROTECTED]> writes:
> Tom Lane <[EMAIL PROTECTED]> wrote on 06-12-2005 15:49:28:
>> Couldn't you have just set autovacuum = off in postgresql.conf? (Unlike
>> some other things, this setting can be changed after postmaster start.)
> If that is true, the documentation
Tom Lane <[EMAIL PROTECTED]> wrote on 06-12-2005
15:49:28:
> Couldn't you have just set autovacuum = off in postgresql.conf? (Unlike
> some other things, this setting can be changed after postmaster start.)
If that is true, the documentation at http://www.postgresql.org/docs/8.1/static/runtime-c
Richard van den Berg <[EMAIL PROTECTED]> writes:
> We are in the process of upgrading our 400GB database from PostgreSQL
> 7.4.7 to 8.1.0. During the pg_restore I noticed that the autovacuum
> process was slowing things down significantly. I should have disabled it
> in postgresql.conf before start
We are in the process of upgrading our 400GB database from PostgreSQL
7.4.7 to 8.1.0. During the pg_restore I noticed that the autovacuum
process was slowing things down significantly. I should have disabled it
in postgresql.conf before starting the restore (duh).
Not wanting to restart the restore
