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

2018-12-08 Thread Andres Freund
On 2018-12-08 15:23:19 -0800, Rob Sargent wrote: > > > > On Dec 8, 2018, at 3:12 PM, Andres Freund wrote: > > > > 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 starti

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

2018-12-08 Thread Rob Sargent
> On Dec 8, 2018, at 3:12 PM, Andres Freund wrote: > > 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,

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

2018-12-08 Thread Andres Freund
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 wit

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

2018-12-08 Thread Bob Lunney
Aurora doesn’t use a typical file system so the RAM usually reserved for the OS file system bufffer cache is instead used for shared_buffers. We run multiple Aurora/ PG instances and they work quite well. There are limitations in superuser private, so be aware of that, but generally speaking

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

2018-12-08 Thread Square Bob
This question is probably more of a fit for the performance list, sorry for the cross post Forwarded Message Subject: amazon aroura config - seriously overcommited defaults? (May be Off Topic) Date: Sat, 8 Dec 2018 12:00:33 -0700 From: Square Bob To: pgsql-gene...