Re: Performance large tables. - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Performance large tables.
Date
Msg-id 20051210232649.GA1193@svana.org
Whole thread Raw
In response to Performance large tables.  (Benjamin Arai <barai@cs.ucr.edu>)
Responses Re: Performance large tables.
List pgsql-general
On Sat, Dec 10, 2005 at 03:22:47PM -0800, Benjamin Arai wrote:
> My issue actually stems from the fact that I cannot do large weekly
> updates on fast enough to meet a weekend window for the following work
> week.  I am currently using a machine with a raid 1, 4GB RAM, and dual
> opteron.  I could go 0+1 but peroformance increase is only about 20%
> from the benchmarks I have read.  ANY suggestions would be greatly
> appreciated.

Since you have given us no information to work with you're not going to
get any specific recommendations either. If you can tell is the things
you do most commonly and are most performance sensetive (exact
commands, timings, versions and settings please) we may be able to
help.
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment

pgsql-general by date:

Previous
From: Benjamin Arai
Date:
Subject: Performance large tables.
Next
From: Benjamin Arai
Date:
Subject: Re: Performance large tables.