Re: performance problem - 10.000 databases - Mailing list pgsql-admin

From Tom Lane
Subject Re: performance problem - 10.000 databases
Date
Msg-id 19628.1068131865@sss.pgh.pa.us
Whole thread Raw
In response to Re: performance problem - 10.000 databases  (Marek Florianczyk <franki@tpi.pl>)
List pgsql-admin
Marek Florianczyk <franki@tpi.pl> writes:
> W li�cie z czw, 06-11-2003, godz. 15:37, Jeff pisze:
>> I would *STRONGLY* advise not running with fsync=false in production as
>> PG _CANNOT_ guaruntee data consistancy in the event of a hardware
>> failure.  It would sure suck to have a power failure screw up your nice
>> db for the users!

> Sure I know, but with WAL it will make fsync every some? seconds, right?

No.  fsync = false turns off fsync of WAL.  It's okay for development
but not when you actually care about integrity of your data.

            regards, tom lane

pgsql-admin by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Microsoft access verses postgresql
Next
From: "scott.marlowe"
Date:
Subject: Re: performance problem - 10.000 databases