[PERFORM] hyperthreadin low performance

2015-07-20 Thread Jeison Bedoya Delgado
PE R820 processor: 4x Intel(R) Xeon(R) CPU E5-4620 v2 @ 2.60GHz eigth-core RAM: 128GB Storage SSD SAN thanks by your help -- Atentamente, JEISON BEDOYA DELGADO ADM.Servidores y comunicaciones AUDIFARMA S.A. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make

[PERFORM] tuning postgresql 9.3.5 and multiple cores

2014-08-25 Thread Jeison Bedoya Delgado
hi, recently i change the hardware of my database 32 cores up to 64 cores and 128GB Ram, but the performance is the same. Perhaps i have to change any parameter in the postgresql.conf?. Thanks by your help -- Atentamente, JEISON BEDOYA DELGADO . -- NOTA VERDE: No imprima este correo a

[PERFORM] limit connections pgpool

2013-10-10 Thread Jeison Bedoya Delgado
Hi, i want to know what is the pgpool parameter for close the connections directly in the database, because the pgpool II close fine the the childs with the life time, but the connection in the database continue open in idle state. this is my pool config num_init_children = 100 max_pool = 8 c

Re: [PERFORM] higth performance write to disk

2013-09-04 Thread Jeison Bedoya Delgado
have SSDs in Raid 10. That behavior is normal, or you can improve writing and reading. thank you very much El 04/09/2013 10:27 a.m., Merlin Moncure escribió: On Wed, Sep 4, 2013 at 10:22 AM, Jeison Bedoya Delgado wrote: Hello, in order to improve the performance of my database included i

[PERFORM] higth performance write to disk

2013-09-04 Thread Jeison Bedoya Delgado
Hello, in order to improve the performance of my database included in the solution SAN SSD disk on RAID 10, but I see that the performance of the database is the same. whichpostgresql.conf parameters that I do recommend to change for use writing more. Thank you very much. -- Sent via pgsql-p