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
= 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
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
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
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
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
