On Fri, 2007-07-13 at 14:00 -0500, Jim C. Nasby wrote: > On Fri, Jul 13, 2007 at 07:11:54PM +0100, Simon Riggs wrote: > > On Fri, 2007-07-13 at 12:38 -0500, Jim C. Nasby wrote: > > > One question... can operations that shortcut the WAL by fsyncing direct > > > to disk also use async commit? I suspect the answer is an implicit "no" > > > because the only examples I can think of all involve DDL, but it's > > > probably worth spelling that out... > > > > They can, but the WAL-avoiding ops are all designed for bulk ops, so > > you'll get something like 0.0001% benefit by using async commit for > > them. > > Yeah, I knew it wouldn't help much, I just wasn't clear on what the > effect would be. I guess I'm also a bit confused... the only shortcut I > know of (COPY into a table created in the same transaction) involves > creating files, so it would be ineligible for async commit, or are there > other shortcuts? Do we list the shortcuts anywhere in the docs?
Wrote that too... http://developer.postgresql.org/pgdocs/postgres/performance-tips.html > > Thanks for reading. > > Thanks for writing. :) -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
