On 5 November 2010 11:14, Thom Brown <thom@xxxxxxxxx> wrote:
Oh, and turn synchronous_commit off too.
On 5 November 2010 10:59, A B <gentosaker@xxxxxxxxx> 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
