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

2016-11-23 Thread Andreas Kretschmer
Am 23. November 2016 23:15:25 MEZ, schrieb Carmen Mardiros : > >various combinations)? How can I investigate what's limiting postgres >from >doing so? Why fsync=off? Please run the queries with EXPLAIN ANALYSE and show us the output. -- Diese Nachricht wurde von meinem Android-Mobiltelefon mi

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

2016-11-23 Thread Carmen Mardiros
I am trying to configure Postgres (version 9.5) to take advantage of very large memory environment. Server configuration has 256GB RAM, 12 cores and 2 SSDs on RAID0 and runs Ubuntu. Swap is set at 4GB. The machine is used for data warehouse operations. Typically only 1 statement runs at a time (bu