| From: | Michael Tharp <gxti(at)partiallystapled(dot)com> |
|---|---|
| To: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: no universally correct setting for fsync |
| Date: | 2010-05-10 14:48:01 |
| Message-ID: | 4BE81CA1.4080201@partiallystapled.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs pgsql-hackers |
On 05/08/2010 04:07 AM, Craig Ringer wrote:
> It's probably worth mentioning that people who want to turn off fsync to
> gain a performance boost should instead look at a RAID controller with a
> BBU so they can safely enable write-back caching, getting most of the
> benefits of fsync=off safely.
Which options specifically should be set if a BBU is in use? Obviously
fsync should be on always, but can full_page_writes be disabled? Are
there other tweaks that can be done?
It would be great to see some practical hints in the documentation while
the fsync part is getting changed.
-- m. tharp
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2010-05-10 15:12:35 | Re: no universally correct setting for fsync |
| Previous Message | Kevin Grittner | 2010-05-08 13:09:51 | Re: [HACKERS] no universally correct setting for fsync |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2010-05-10 14:57:11 | Re: max_standby_delay considered harmful |
| Previous Message | Andres Freund | 2010-05-10 12:11:56 | Re: max_standby_delay considered harmful |