| From: | Vivek Khera <vivek(at)khera(dot)org> |
|---|---|
| To: | PG-General General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Performance large tables. |
| Date: | 2005-12-12 22:15:07 |
| Message-ID: | CE02ED81-E31D-459C-A421-87422197378B@khera.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Dec 10, 2005, at 6:37 PM, Benjamin Arai wrote:
> For the most part the updates are simple one liners. I currently
> commit in large batch to increase performance but it still takes a
> while as stated above. From evaluating the computers performance
> during an update, the system is thrashing both memory and disk. I
> am currently using Postgresql 8.0.3.
Then buy faster disks. My current favorite is to use U320 15kRPM
disks using a dual-chanel RAID controller with 1/2 the disks on one
channel and 1/2 on the other and mirroring them across channels, then
striping down the mirrors (ie, RAID10).
I use no fewer than 6 disks (RAID 10) for data and 2 for pg_log in a
RAID1.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-12-12 22:42:05 | Re: View with an outer join - is there any way to optimise this? |
| Previous Message | John Gray | 2005-12-12 22:11:56 | Re: OpenOffice 2 and Postgresql 8.1 How to? |