From: | "Mattias Kregert" <mattias(at)kregert(dot)se> |
---|---|
To: | <shridhar_daithankar(at)persistent(dot)co(dot)in>, "PostgreSQL List" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Datatypes and performance |
Date: | 2003-07-07 11:30:09 |
Message-ID: | 00ed01c3447b$1fc24f40$09000a0a@kregert.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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+check badblocks and then restore from the backup. I can't see how fsync would help in the case of disk crash. Without reliable raid or something i think this would be a catastrophic failure => get new hardware: disk/ram/computer/building whatever 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 journalling filesystem. 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(at)persistent(dot)co(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2003-07-07 11:46:13 | Re: Datatypes and performance |
Previous Message | Shridhar Daithankar | 2003-07-07 11:09:37 | Re: Datatypes and performance |