| From: | Mats Lofkvist <mal(at)algonet(dot)se> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Performance while loading data and indexing |
| Date: | 2002-09-27 10:49:17 |
| Message-ID: | y2qwup71zde.fsf@algonet.se |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-performance |
shridhar_daithankar(at)persistent(dot)co(dot)in ("Shridhar Daithankar") writes:
[snip]
>
> Couple MB of data per sec. to disk is just not saturating it. It's a RAID 5
> setup..
>
RAID5 is not the best for performance, especially write performance.
If it is software RAID it is even worse :-).
(Note also that you need to check that you are not saturating the
number of seeks the disks can handle, not just the bandwith.)
Striping should be better (combined with mirroring if you need the
safety, but with both striping and mirroring you may need multiple
SCSI channels).
_
Mats Lofkvist
mal(at)algonet(dot)se
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2002-09-27 11:29:46 | Re: [JDBC] Prepared statement performance... |
| Previous Message | Mats Lofkvist | 2002-09-27 10:40:13 | Re: [HACKERS] Performance while loading data and indexing |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Larry Rosenman | 2002-09-27 10:49:27 | Re: hacker help: PHP-4.2.3 patch to allow restriction of |
| Previous Message | Mats Lofkvist | 2002-09-27 10:40:13 | Re: [HACKERS] Performance while loading data and indexing |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2002-09-27 15:16:03 | Re: Performance while loading data and indexing |
| Previous Message | Mats Lofkvist | 2002-09-27 10:40:13 | Re: [HACKERS] Performance while loading data and indexing |