Thread: pgrestore command

On Fri, Feb 28, 2014 at 4:41 PM, Arun P.L <arunpl@hotmail.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

On 2/28/2014 5:06 AM, Michael Paquier wrote:
> 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).

and that could be 200% or more if there is IO and/or CPU contention from
other virtual machines on the same physical host.



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast

On Sat, Mar 1, 2014 at 3:23 AM, John R Pierce <pierce@hogranch.com> wrote:
> On 2/28/2014 5:06 AM, Michael Paquier wrote:
>>
>> 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).
>
>
> and that could be 200% or more if there is IO and/or CPU contention from
> other virtual machines on the same physical host.
Definitely. Thanks for precising that as well.
--
Michael