| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Tomasz Myrta <jasiek(at)klaster(dot)net>, Rafal Kedziorski <rafcio(at)polonium(dot)de> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: [PERFORM] Good performance? |
| Date: | 2003-02-17 20:03:58 |
| Message-ID: | 200302171203.58611.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc pgsql-performance |
Rafal, Tomasz,
> It is possible when you have "fsync=false" in your postgresql.conf.
> (don't change it if you don't have to).
You should NOT turn off fsync unless you know what you are doing. With fsync
off, your database can be unrecoverably corrupted after an unexpected
power-out, and you will be forced to restore from your last backup.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dirk Bromberg | 2003-02-17 20:36:54 | ConnectionPool newbie |
| Previous Message | Barry Lind | 2003-02-17 18:10:38 | Re: Support of XA datasources? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-02-18 02:49:31 | Re: [HACKERS] Changing the default configuration (was Re: |
| Previous Message | Barry Lind | 2003-02-17 17:50:26 | Re: Good performance? |