On 5 November 2010 11:14, Thom Brown <t...@linux.com> wrote: > On 5 November 2010 10:59, A B <gentosa...@gmail.com> wrote: > >> Hi there. >> >> If you just wanted PostgreSQL to go as fast as possible WITHOUT any >> care for your data (you accept 100% dataloss and datacorruption if any >> error should occur), what settings should you use then? >> >> > Turn off fsync and full_page_writes (i.e. running with scissors). > > Also depends on what you mean by "as fast as possible". Fast at doing > what? Bulk inserts, selecting from massive tables? > > Oh, and turn synchronous_commit off too.
-- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935