Re: [PERFORM] How to tune Postgres to take advantage of 256GB RAM hardware

It's PostgreSQL 9.5.4 On Thu, 24 Nov 2016 at 11:46 Imre Samu wrote: > > I am trying to configure Postgres (version 9.5) > > This is the latest PG 9.5 ? ( = 9.5.5 > ? [ > Release Date : 2016-10-27 ] ) > >

Re: [PERFORM] How to tune Postgres to take advantage of 256GB RAM hardware

> I am trying to configure Postgres (version 9.5) This is the latest PG 9.5 ? ( = 9.5.5 ? [ Release Date : 2016-10-27 ] ) 2016-11-24 9:17 GMT+01:00 Carmen Mardiros : > Hi Andreas, > > Thanks for the reply.

Re: [PERFORM] How to tune Postgres to take advantage of 256GB RAM hardware

Hi Andreas, Thanks for the reply. fsync is off because I don't care if the data gets corrupted in this environment if it means a performance gain, as it's only a minor inconvenience to restore from backups. Here is the query itself that pushes memory usage to 100%: http://pastebin.com/VzCAerwd