Re: copying a large database to change encoding

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: copying a large database to change encoding
Дата
Msg-id CALd+dce1CB3aArGbNzAApP+TQveHKGYn6wkSFHmJhvWMroBYkQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: copying a large database to change encoding  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
It should take about as much time as cp -r of the directory for that
DB would take.


On Tue, Oct 14, 2014 at 1:58 PM, Adrian Klaver
<adrian.klaver@aklaver.com> wrote:
> On 10/14/2014 10:43 AM, Matthew Chambers wrote:
>>
>> Thanks,
>>
>> How long did it take to complete?
>>
>
> I did not time that copy. I just tried with a small database(76 MB on disk)
> and it took 27 secs. This is using Linux on an older(3 yrs+) i386 machine.
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: copying a large database to change encoding
Следующее
От: Abelard Hoffman
Дата:
Сообщение: Will pg_repack improve this query performance?