On 5 November 2010 10:59, A B <gentosaker@xxxxxxxxx> wrote:
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?
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?
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
