pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jeffrey D. Brower <jeff@pointhere.net>
To: Shankar K <shan0075@yahoo.com>
To: pgsql-performance@postgresql.org
Subject: Re: ext3 filesystem / linux 7.3
Date: Tue, 1 Apr 2003 12:33:15 -0500
Message-ID: <08f801c2f874$c6aac3d0$0b02a8c0@pointhere.net> (raw)
References: <20030331205544.19785.qmail@web21104.mail.yahoo.com>

What is the URL of that article?  I understood that ext2 was faster with PG
and so I went to a lot of trouble of creating an ext2 partition just for PG
and gave up the journalling to do that.  Something about double effort since
PG already does a lot of that.

Bruce, is there a final determination of which is faster/safer?

    Jeff

----- Original Message -----
From: "Shankar K" <shan0075@yahoo.com>
To: <pgsql-performance@postgresql.org>
Sent: Monday, March 31, 2003 3:55 PM
Subject: [PERFORM] ext3 filesystem / linux 7.3


> hi there,
>
> I was reading bruce's 'postgresql hardware performance
> tuning' article and he has suggested ext3 filesystem
> with data mode = writeback for high performance.
>
> I would really appreciate if anyone could share your
> experiences with ext3 from a production stand point or
> any other suggestions for best read/write performance.
>
> Our applications is an hybrid of heavy inserts/updates
> and DSS queries.
>
> version - postgres 7.3.2
> hardware - raid 5 (5 x 73 g hardware raid), 4g ram, 2
> * 2.8 GHz cpu, redhat 7.3
>
> Note : we don't have the luxury of raid 1+0 (dedicated
> disks) for xlog and clog files to start with but may
> be down the line we might look into those options, but
> for now i've planned on having them on local drives
> rather than raid 5.
>
> thanks for any inputs,
> Shankar
>
>
>
>
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
> http://platinum.yahoo.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org




view thread (42+ messages)  latest in thread

Message-ID: <08f801c2f874$c6aac3d0$0b02a8c0@pointhere.net>
Permalink:  ../08f801c2f874$c6aac3d0$0b02a8c0@pointhere.net/
Also on:    postgresql.org/message-id/08f801c2f874$c6aac3d0$0b02a8c0@pointhere.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: jeff@pointhere.net, shan0075@yahoo.com
  Subject: Re: ext3 filesystem / linux 7.3
  In-Reply-To: <08f801c2f874$c6aac3d0$0b02a8c0@pointhere.net>
  References: <20030331205544.19785.qmail@web21104.mail.yahoo.com> <08f801c2f874$c6aac3d0$0b02a8c0@pointhere.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox