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 2
= 16
max size of message (bytes) = 65536
default max size of queue (bytes) = 65536
Is there anything that i can do to still improve 9.0.2 performance. the
performance (tps) that i got is only 10% is it ideal, or should i need to
get more?
Thanks
Deepak
On Wed, Jan 26, 2011 at 7:12 PM, DM wrote
Hello There,
I have a table x and a history table x_hist, whats the best way to update
the history table.
should i need to use triggers or embed a code in my script to update the
history table?
what is the performance impact of a trigger versus embedding the code in the
script?
thanks for your
Is there any script/tool to identify if the table requires full vacuum? or
to re-index an existing index table?
Thanks
Deepak
On Fri, Jan 22, 2010 at 12:11 AM, DM wrote:
> Hello All,
>
> How to identify if a table requires full vacuum? How to identify when to do
> re-index on an ex
Hello All,
How to identify if a table requires full vacuum? How to identify when to do
re-index on an existing index of a table?
Is there any tool for the above?
Thanks
Deepak Murthy
