[PERFORM] hyperthreadin low performance

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

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

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

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

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

[PERFORM] to many locks held

Hi everybody, In recent days, we have seen many processes in reaching the lock held 5000. At that time my machine will become sluggish and no response from the database. I tried to change configuration parameters, but have not found anything satisfactory. further in meeting log messages like t

Re: [PERFORM] Process in state BIND, authentication, PARSE

= 128MB work_mem = 1024MB maintenance_work_mem = 1024MB wal_buffers = 256 checkpoint_segments = 103 effective_cache_size = 4096MB thanks Atentamente, JEISON BEDOYA DELGADO Adm. Servidores y Comunicaciones AUDIFARMA S.A. El 08/07/2013 11:40 a.m., Andrew Dunstan escribió: On 07/08/2013 12:22 PM

[PERFORM] Process in state BIND, authentication, PARSE

Hi, i want to know why in my database the process stay in BID, PARSE, autentication, startup by a couple minuts, generating slow in the process, perhaps tunning parameters? or configuration of operating system (Linux RHEL 6). Thanks by your help -- Atentamente, JEISON BEDOYA DELGADO Adm

[PERFORM] Performance autovaccum

Hi, i have a postgresql 9.2.2, but i don´t use autovaccum but i want to begin to use it. some recommendation about the optimal configuration? or some link to explain it. Thanks -- Atentamente, JEISON BEDOYA DELGADO Adm. Servidores y Comunicaciones AUDIFARMA S.A. -- Sent via pgsql

Re: [PERFORM] performance database for backup/restore

the Fiber channel SAN have capacity of 8GB and tthe i/o transfer to the disk is no Upper to 1 GB. can you explainme again how do you do a 6bg/min for pd_dump thanks Atentamente, JEISON BEDOYA DELGADO Adm. Servidores y Comunicaciones AUDIFARMA S.A. El 21/05/2013 11:11 a.m., Jeff Janes escrib

[PERFORM] performance database for backup/restore

very much -- Atentamente, JEISON BEDOYA DELGADO Adm. Servidores y Comunicaciones AUDIFARMA S.A. -- NOTA VERDE: No imprima este correo a menos que sea absolutamente necesario. Ahorre papel, ayude a salvar un arbol. Este