Re: Datatypes and performance - Mailing list pgsql-general

From Mattias Kregert
Subject Re: Datatypes and performance
Date
Msg-id 00ed01c3447b$1fc24f40$09000a0a@kregert.se
Whole thread Raw
In response to Re: Datatypes and performance  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Responses Re: Datatypes and performance
Re: Datatypes and performance
List pgsql-general
In the case of disk failure, the files will probably be damaged anyway and then i'll have to install new hardware or
format+checkbadblocks and then restore from the backup. I can't see how fsync would help in the case of disk crash.
Withoutreliable raid or something i think this would be a catastrophic failure => get new hardware:
disk/ram/computer/buildingwhatever and go find the (remote) backup. 

In the case of power failure, you'll *might* have to restore from backup unless you use ReiserFS or some other
journallingfilesystem. I use ReiserFS. I also have a UPS installed, just to be sure... 

Journalling FS will fix the FS problems, so the files are ok.
PG journal will fix the PG problems so the tables will be ok.


From: "Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>
> On 7 Jul 2003 at 12:59, Mattias Kregert wrote:
>
> > First of all, disable FSYNC... that will speed things up a lot!
>
> That shouldn't have been done so casually.  Though can cause performance boost
> and it degrades reliability of data as it can cause data corruption in case of
> power/disk failure.
>
> Bye
>  Shridhar


pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: Datatypes and performance
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Datatypes and performance