analyze running very slow compared to a
different box with much less configuration
2011/3/25 DM dm.a...@gmail.com:
gettimeofday() on my new box is slow, after further research we found
that, when we set ACPI=Off, we got a good clock performance even the
explain analyze gave approximately gave
You might take a look here:
http://archives.postgresql.org/pgsql-admin/2011-01/msg00050.php
My problem had to do with the speed of gettimeofday. You might want to do some
special setting regarding
your box's way of reading time for the hw clock.
Στις Thursday 24 March 2011 04:04:21 ο/η DM
On Thu, Mar 24, 2011 at 11:11, Achilleas Mantzios
ach...@matrix.gatewaynet.com wrote:
My problem had to do with the speed of gettimeofday. You might want to do
some special setting regarding
your box's way of reading time for the hw clock.
Just for extra info, on x86, TSC is usually the fast
Στις Thursday 24 March 2011 13:39:19 ο/η Marti Raudsepp έγραψε:
On Thu, Mar 24, 2011 at 11:11, Achilleas Mantzios
ach...@matrix.gatewaynet.com wrote:
My problem had to do with the speed of gettimeofday. You might want to do
some special setting regarding
your box's way of reading time for
Thank you for your research on and posting on it, when I first encountered
this issue I saw your posting/research on this issue, this gave me a great
insight.
gettimeofday() on my new box is slow, after further research we found that,
when we set ACPI=Off, we got a good clock performance even the
Hi All,
pg9.0.3 explain analyze running very slow compared to old box with much less
configuration.
But actual query is performing much better than the old server.
old Server===
OS: CentOS release 5.4 (Final)
Linux Server 2.6.18-164.6.1.el5 #1 SMP Tue Nov 3 16:12:36 EST