Postgres Pro
Downloads
Home   >   mailing lists

Re: Running PostgreSQL as fast as possible no matter the consequences - Mailing list pgsql-performance

From Thom Brown
Subject Re: Running PostgreSQL as fast as possible no matter the consequences
Date
Msg-id AANLkTikzrFyQMtEMAu0ok1mrvy5D_LTSTDs7gmB0nMmD@mail.gmail.com
Whole thread Raw
In response to Re: Running PostgreSQL as fast as possible no matter the consequences  (Thom Brown <thom@linux.com>)
List pgsql-performance
Tree view
On 5 November 2010 11:14, Thom Brown <thom@linux.com> wrote:
On 5 November 2010 10:59, A B <gentosaker@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

pgsql-performance by date:

Previous
From: Thom Brown
Date:
Subject: Re: Running PostgreSQL as fast as possible no matter the consequences
Next
From: Guillaume Cottenceau
Date:
Subject: Re: Running PostgreSQL as fast as possible no matter the consequences