Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic)

From: Andres Freund <andres(at)anarazel(dot)de>
To: Jeremy Schneider <schnjere(at)amazon(dot)com>
Cc: Square Bob <square_bob(at)yahoo(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic)
Date: 2018-12-08 23:12:42
Message-ID: 20181208231242.t66zpocct36m4o46@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

On 2018-12-08 12:06:23 -0800, Jeremy Schneider wrote:
> On RDS PostgreSQL, the default is 25% of your server memory. This seems
> to be pretty widely accepted as a good starting point on PostgreSQL.

FWIW, I think it's widely cited, but also bad advice. 25% for a OLTP
workload on a 1TB machine with a database size above 25% is a terrible
idea.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2018-12-08 23:23:19 Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic)
Previous Message Jeremy Schneider 2018-12-08 20:06:23 Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic)

Browse pgsql-performance by date

  From Date Subject
Next Message Rob Sargent 2018-12-08 23:23:19 Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic)
Previous Message Jeremy Schneider 2018-12-08 20:06:23 Re: amazon aroura config - seriously overcommited defaults? (May be Off Topic)