| From: | Curt Sampson <cjs(at)cynic(dot)net> |
|---|---|
| To: | Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Large databases, performance |
| Date: | 2002-10-07 02:27:04 |
| Message-ID: | Pine.NEB.4.44.0210071124410.443-100000@angelic.cynic.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-performance pgsql-sql |
On Thu, 3 Oct 2002, Shridhar Daithankar wrote:
> Well, we were comparing ext3 v/s reiserfs. I don't remember the journalling
> mode of ext3 but we did a 10 GB write test. Besides converting the RAID to RAID-
> 0 from RAID-5 might have something to do about it.
That will have a massive, massive effect on performance. Depending on
your RAID subsystem, you can except RAID-0 to be between two and twenty
times as fast for writes as RAID-5.
If you compared one filesystem on RAID-5 and another on RAID-0,
your results are likely not at all indicative of file system
performance.
Note that I've redirected followups to the pgsql-performance list.
Avoiding cross-posting would be nice, since I am getting lots of
duplicate messages these days.
cjs
--
Curt Sampson <cjs(at)cynic(dot)net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Curt Sampson | 2002-10-07 02:30:57 | Re: Large databases, performance |
| Previous Message | Curt Sampson | 2002-10-07 01:57:47 | Re: [JDBC] Prepared statement performance... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Curt Sampson | 2002-10-07 02:30:57 | Re: Large databases, performance |
| Previous Message | Benjamin Stewart | 2002-10-07 02:00:23 | Moving to PostGres |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Curt Sampson | 2002-10-07 02:30:57 | Re: Large databases, performance |
| Previous Message | Curt Sampson | 2002-10-06 15:52:24 | Re: [HACKERS] Performance while loading data and indexing |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Curt Sampson | 2002-10-07 02:30:57 | Re: Large databases, performance |
| Previous Message | Josh Berkus | 2002-10-07 00:11:46 | Re: foreign key problem |