Обсуждение: pgrestore command
Hi
Is there any chances for any performance issues with pg_restore when changing the servers, like openvz, xen, etc.? Will the server difference make the time of restore longer in this case?
Thanks
Arun
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