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

From A B
Subject Re: Running PostgreSQL as fast as possible no matter the consequences
Date
Msg-id AANLkTi=K6UWayGRRA56AZh_kUjFM5M2pqceD+1z=XfBf@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
> 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 :-)

pgsql-performance by date:

Previous
From: Szymon Guz
Date:
Subject: Re: Running PostgreSQL as fast as possible no matter the consequences
Next
From: Craig Ringer
Date:
Subject: Re: Running PostgreSQL as fast as possible no matter the consequences