| From: | Julien Cigar <jcigar(at)ulb(dot)ac(dot)be> |
|---|---|
| To: | Andres Freund <andres(at)2ndquadrant(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Postgres becoming slow, only full vacuum fixes it |
| Date: | 2012-09-24 12:53:59 |
| Message-ID: | 506057E7.5090008@ulb.ac.be |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 09/24/2012 14:34, Andres Freund wrote:
> On Monday, September 24, 2012 02:21:09 PM Julien Cigar wrote:
>> 5) synchronous_commit = off should only be used if you have a
>> battery-backed write cache.
> Huh? Are you possibly confusing this with full_page_writes?
indeed...! sorry for that
(note that you still have a (very) small chance of loosing data with
synchronous_commit = off if your server crashes between two "commit chunks")
> Greetings,
>
> Andres
--
No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.
| Attachment | Content-Type | Size |
|---|---|---|
| jcigar.vcf | text/x-vcard | 292 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2012-09-24 13:34:31 | Re: Postgres becoming slow, only full vacuum fixes it |
| Previous Message | Andres Freund | 2012-09-24 12:34:56 | Re: Postgres becoming slow, only full vacuum fixes it |