| From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org, Tom Wilcox <hungrytom(at)gmail(dot)com> |
| Subject: | Re: Configure Postgres From SQL |
| Date: | 2010-07-12 19:02:04 |
| Message-ID: | 4C3B66AC.2060405@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Andres Freund wrote:
> What you can change (and that makes quite a bit of sense in some situations)
> is the "synchronous_commit" setting.
>
Right. In almost every case where people think they want to disable
fsync, what they really should be doing instead is turning off
synchronous commit--which is a user-land tunable per session:
SET synchronous_commit=false;
And potentially increasing wal_writer_delay on the server too:
http://www.postgresql.org/docs/current/static/wal-async-commit.html
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2010-07-12 19:34:02 | Re: PostgreSQL 9.0 beta 3 release announcement |
| Previous Message | Greg Smith | 2010-07-12 18:54:53 | Re: PG_DUMP very slow because of STDOUT ?? |