Re: Low performance between datacenters

El dom, 7 jul 2024 a la(s) 3:17 p.m., Tamás PAPP (tomposm...@gmail.com) escribió: > hi All, > > I am new on the list. > I hope someone can give me an adequate answer or good advice about my > problem. > > I have a client (normally a web service, for testing the psql client) in > GCP. There is a PS

Re: HDD vs SSD without explanation

2018-01-15 20:25 GMT-03:00 Neto pr : > 2018-01-15 17:55 GMT-02:00 Fernando Hevia : > > > > > > 2018-01-15 15:32 GMT-03:00 Georg H. : > >> > >> > >> Hello Neto > >> > >> Am 14.01.2018 um 21:44 schrieb Neto pr: > >>> &g

Re: HDD vs SSD without explanation

2018-01-15 15:32 GMT-03:00 Georg H. : > > Hello Neto > > Am 14.01.2018 um 21:44 schrieb Neto pr: > >> Dear all >> >> Someone help me analyze the two execution plans below (Explain ANALYZE >> used), is the query 9 of TPC-H benchmark [1]. >> I'm using a server HP Intel Xeon 2.8GHz/4-core - Memory 8

Re: Setting effective_io_concurrency in VM?

El 27 nov. 2017 15:24, "Don Seiler" escribió: Good afternoon. We run Postgres (currently 9.2, upgrading to 9.6 shortly) in VMWare ESX machines. We currently have effective_io_concurrency set to the default of 1. I'm told that the data volume is a RAID 6 with 14 data drives and 2 parity drives. I