Re: 7 hrs for a pg_restore?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 7 hrs for a pg_restore?
Дата
Msg-id 9755.1203526446@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 7 hrs for a pg_restore?  (Erik Jones <erik@myemma.com>)
Ответы Re: 7 hrs for a pg_restore?  (Matthew <matthew@flymine.org>)
Re: 7 hrs for a pg_restore?  (Erik Jones <erik@myemma.com>)
Re: 7 hrs for a pg_restore?  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-performance
Erik Jones <erik@myemma.com> writes:
> On Feb 20, 2008, at 8:14 AM, Gregory Stark wrote:
>> I would suggest leaving out the && which only obfuscate what's
>> going on here.
>>
>> PGOPTIONS=... pg_restore ...
>>
>> would work just as well and be clearer about what's going on.

> Right, that's just an unnecessary habit of mine.

Isn't that habit outright wrong?  ISTM that with the && in there,
what you're doing is equivalent to

    PGOPTIONS=whatever
    pg_restore ...

This syntax will set PGOPTIONS for the remainder of the shell session,
causing it to also affect (say) a subsequent psql invocation.  Which is
exactly not what is wanted.

            regards, tom lane

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

Предыдущее
От: Erik Jones
Дата:
Сообщение: Re: 7 hrs for a pg_restore?
Следующее
От: Matthew
Дата:
Сообщение: Re: 7 hrs for a pg_restore?