| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | "Arun P(dot)L" <arunpl(at)hotmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pgrestore command |
| Date: | 2014-02-28 13:06:00 |
| Message-ID: | CAB7nPqRzDPkCJdR66fGNM5EO_aaJK3pa5BCTfpiGiZz5GnKh1Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Feb 28, 2014 at 4:41 PM, Arun P.L <arunpl(at)hotmail(dot)com> wrote:
> Hi
>
> Is there any chances for any performance issues with pg_restore when
> changing the servers, like openvz, xen, etc.?
You could expect a loss of 20% at I/O level by using a virtualized
environment compared to a physical server with similar hardware (rule
of thumb, number more or less general by experience). Then for
different hardwares, yes you will get performance differences...
> Will the server difference make the time of restore longer in this case?
Depends on the hardware, as well as on the environment used... It is
hard to tell without any details...
Regards,
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2014-02-28 14:53:24 | Re: Josh's Comments on Hstore / Jsonb |
| Previous Message | Arun P.L | 2014-02-28 07:41:01 | pgrestore command |