Re: Running PostgreSQL as fast as possible no matter the consequences

From: A B <gentosaker(at)gmail(dot)com>
To: Thom Brown <thom(at)linux(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Running PostgreSQL as fast as possible no matter the consequences
Date: 2010-11-05 11:24:13
Message-ID: AANLkTi=K6UWayGRRA56AZh_kUjFM5M2pqceD+1z=XfBf@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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?

I guess some tuning has to be done to make it work well with the
particular workload (in this case most selects). But thanks for the
suggestions on the more general parameters.

"running with scissors" sounds nice :-)

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Craig Ringer 2010-11-05 11:27:41 Re: Running PostgreSQL as fast as possible no matter the consequences
Previous Message Szymon Guz 2010-11-05 11:23:36 Re: Running PostgreSQL as fast as possible no matter the consequences