Re: [PERFORM] hyperthreadin low performance

2015-07-23 Thread domenico febbo
is the problem also in PostgreSQL 9.4.x? I'm going to buy a production's server with 4 sockets E7-4850 12 cores so 12*4 = 48 cores (and 96 threads using HT). What do you suggest? Using or not HT? BR Domenico 2015-07-21 11:07 GMT+02:00 Mark Kirkwood : > On 21/07/15 20:04, David Rowley wrote: >> >

Re: [PERFORM] Some tuning suggestions on a Red Hat 6.7 - PG 9.5.3 production environment

2016-11-14 Thread domenico febbo
dear Pietro, are you sure about effective_io_concurrency = 30 could you please explain the type of disk storage? Il 14/Nov/2016 12:46, "Pietro Pugni" ha scritto: > Dear list, > I’m looking for some guidelines on how to optimize the configuration of a > production database dedicated to a DWH ap