Re: Performance while loading data and indexing - Mailing list pgsql-general

From Mats Lofkvist
Subject Re: Performance while loading data and indexing
Date
Msg-id y2qwup71zde.fsf@algonet.se
Whole thread Raw
In response to Performance while loading data and indexing  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Responses Re: Performance while loading data and indexing  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
shridhar_daithankar@persistent.co.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@algonet.se

pgsql-general by date:

Previous
From: Mats Lofkvist
Date:
Subject: Re: [HACKERS] Performance while loading data and indexing
Next
From: Dave Cramer
Date:
Subject: Re: [JDBC] Prepared statement performance...