Re: Tuning PostgreSQL - Mailing list pgsql-performance

From Alexander Priem
Subject Re: Tuning PostgreSQL
Date
Msg-id 012e01c34f85$ab8990f0$b696a8c0@APR
Whole thread Raw
In response to Re: Tuning PostgreSQL  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
List pgsql-performance
Thanks, i'll look further into these mount setting.

I was just thinking, the server will have a (RAID) controller containing
128Mb of battery-backed cache memory. This would really speed up inserts to
the disk and would prevent data loss in case of a power-down also.

What would you guys think of not using RAID5 in that case, but just a really
fast 15.000 rpm SCSI-320 disk?

Kind regards,
Alexander.


----- Original Message -----
From: "Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>
To: <pgsql-performance@postgresql.org>
Sent: Monday, July 21, 2003 2:05 PM
Subject: Re: [PERFORM] Tuning PostgreSQL


> On 21 Jul 2003 at 13:45, Alexander Priem wrote:
>
> > So where can I set the noatime & data=writeback variables? They are not
> > PostgreSQL settings, but rather Linux settings, right? Where can I find
> > these?
>
> These are typicaly set in /etc/fstab.conf. These are mount settings. man
mount
> for more details.
>
> The second setting data=writeback is ext3 specific, IIRC.
>
> HTH
>
> Bye
>  Shridhar
>
> --
> History tends to exaggerate. -- Col. Green, "The Savage Curtain", stardate
> 5906.4
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


pgsql-performance by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: Tuning PostgreSQL
Next
From: Tom Lane
Date:
Subject: Re: Optimizer differences between 7.2 and 7.3