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?
ThanksArun
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general