| From: | Vick Khera <vivek(at)khera(dot)org> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | Matthew Chambers <mchambers(at)wetafx(dot)co(dot)nz>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: copying a large database to change encoding |
| Date: | 2014-10-14 19:17:48 |
| Message-ID: | CALd+dce1CB3aArGbNzAApP+TQveHKGYn6wkSFHmJhvWMroBYkQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Abelard Hoffman | 2014-10-15 02:33:46 | Will pg_repack improve this query performance? |
| Previous Message | Adrian Klaver | 2014-10-14 17:58:13 | Re: copying a large database to change encoding |