Re: Patch for pg_upgrade to turn off autovacuum

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Patch for pg_upgrade to turn off autovacuum
Дата
Msg-id A71F6AE6-792B-4977-9C6D-A82DD81DC831@gmail.com
обсуждение исходный текст
Ответ на Re: Patch for pg_upgrade to turn off autovacuum  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Patch for pg_upgrade to turn off autovacuum  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
On Apr 21, 2011, at 6:22 PM, Bruce Momjian <bruce@momjian.us> wrote:
> Tom Lane wrote:
>> Bruce Momjian <bruce@momjian.us> writes:
>>> Tom Lane wrote:
>>>> Huh?  Why would that be?  Seems like you've done something in the wrong
>>>> place if that's an issue.
>>
>>> Yeah, it is complicated.  I don't really care if autovacuum runs on the
>>> old cluster (we only move the files while the server is down).  We only
>>> want autovacuum not to mess with the relfrozenxids we set on the new
>>> cluster while the table file is empty.
>>
>>> The other issue is that the old alpha binary will not know about the -b
>>> flag and hence will not start.
>>
>> Well, once again, why are you trying to do that?  It's not the source
>> postmaster that needs this flag.
>
> Well, consider that this also locks out non-super users so I figured it
> would be good to run the old and new in the same binary upgrade mode.
> Again, we can do just the new cluster for 9.1.   I can also control the
> behavior based on the catalog version number, which seems the most
> logical.

I think you are over-engineering this. Just use it for the new cluster only, full stop, and you'll be right as rain.

...Robert

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: "stored procedures"
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: "stored procedures"