| From: | Stephen Frost <sfrost(at)snowman(dot)net> |
|---|---|
| To: | Waldo Nell <pwnell(at)telkomsa(dot)net> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Recommended optimisations slows down PostgreSQL 8.4 |
| Date: | 2011-08-12 21:07:42 |
| Message-ID: | 20110812210742.GB12765@tamriel.snowman.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
* Waldo Nell (pwnell(at)telkomsa(dot)net) wrote:
> The fsync = off was because the production system runs on a uber expensive SAN system with multipathing over Fibre Channel, it is on UPS and backup generators in a secure datacenter, and we have daily backups we can fall back to.
So, two points: #1- the uber-expensive SAN should make twiddling fsync
have much less of an effect on performance than in a non-SAN/non-BBWC
environment, so you might validate that you really need it off. #2- the
SAN, FC, UPS, etc will be of no help if the OS or PG crash. Seems
pretty harsh to resort back to a daily backup in the event the OS reboots
due to some wacky NMI, or the ASR going haywire..
Thanks,
Stephen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hyelluas | 2011-08-12 21:29:51 | How to see memory usage using explain analyze ? |
| Previous Message | Tom Lane | 2011-08-12 18:41:01 | Re: Recommended optimisations slows down PostgreSQL 8.4 |