On Wed, Jul 22, 2009 at 12:52 AM, Kelvin Quee wrote:
> I have been staring at *top* for a while and it's mostly been 40% in
> userspace and 30% in system. Wait is rather low and never ventures
> beyond 1%.
Certainly seems like you are CPU bound.
> My hardware is a duo core AMD Athlon64 X2 5000+,
kelv...@gmail.com (Kelvin Quee) writes:
> I will go look at Slony now.
It's worth looking at, but it is not always to be assumed that
replication will necessarily improve scalability of applications; it's
not a "magic wand" to wave such that "presto, it's all faster!"
Replication is helpful from
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> I have a db which is being constantly updated and queried by a few
> computers. We are doing datamining. The machine is running on a
> moderately powered
On Wed, Jul 22, 2009 at 1:52 AM, Kelvin Quee wrote:
> Hi Scott,
>
> Thanks for the quick reply.
>
> I have been staring at *top* for a while and it's mostly been 40% in
> userspace and 30% in system. Wait is rather low and never ventures
> beyond 1%.
>
> My hardware is a duo core AMD Athlon64 X2 50
Hi Scott,
Thanks for the quick reply.
I have been staring at *top* for a while and it's mostly been 40% in
userspace and 30% in system. Wait is rather low and never ventures
beyond 1%.
My hardware is a duo core AMD Athlon64 X2 5000+, 1GB RAM and a single
160 GB SATA II hard disk drive.
I will g
On Tue, Jul 21, 2009 at 9:47 PM, Kelvin Quee wrote:
> Hi Performance Wizards!
>
> I need advice on this.
>
> I have a db which is being constantly updated and queried by a few
> computers. We are doing datamining. The machine is running on a
> moderately powered machine and processors constantly hi
Hi Performance Wizards!
I need advice on this.
I have a db which is being constantly updated and queried by a few
computers. We are doing datamining. The machine is running on a
moderately powered machine and processors constantly hit 90%.
At the same time, we need to present these data on a web
