Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qVoPD-001HZc-WB for pgsql-general@arkaria.postgresql.org; Tue, 15 Aug 2023 07:23:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qVoPC-00BqXY-8H for pgsql-general@arkaria.postgresql.org; Tue, 15 Aug 2023 07:23:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qVoPB-00BqXQ-GT for pgsql-general@lists.postgresql.org; Tue, 15 Aug 2023 07:23:54 +0000 Received: from sonic313-15.consmr.mail.bf2.yahoo.com ([74.6.133.125]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qVoP7-000Ey4-MD for pgsql-general@lists.postgresql.org; Tue, 15 Aug 2023 07:23:52 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1692084226; bh=63VeKLzKUJ6NJ7jfAhRB8FVrO01va4Xl4L9qTz+5ChA=; h=Date:From:To:Subject:References:From:Subject:Reply-To; b=Jcq+d5VK1VXm9OLF4S1LP3iUi89mmbAfTaIdEkkZ3+sWcr3Smo+yPd6/ZPIO3QfJWWe5nwOynqS1Rsvemw7UQI+vgDDUI7G9DFC8cFEPKwcbmeStLFosbReKVmQZLsaHdLRyJXxF788kYZ6kCnG8jEspw2FmA+DHHOuqG8GN4XJ79IMRlrSdw6BYt8/T6ehhBk2ANXTnEuCbU6IhhpT28F6TKKEEIscMkGmB4QYb0J5klQJHY9KtgheC0SatvVjMEnzA8MavMYnobYBSzZeCmxT5wWMoiiCaReaNSRw5X3pqxEHUl8kV2Wt1TLaYXl5PUcg6BnKV2tVB8+0qwE0f5Q== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1692084226; bh=Go1+exWSYGLY85EfYM0c19pdkG36A4FvkwZo10XorYs=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=jN9ZYFkRP2Sj5FCzAAD0fOc7OcSwmsHudDxljF3OdYavgGKvansABiRHX8w03mJVdz4ptJcPgZDgv76amEmG8qJwht9/WSEKlJleBNUec4g5zWqKaXNYPfZUqoGMnQIWCkwT7xHQJ+Wi+k81Qw0yAIEU1FALxdlXpaK4FVQiL9nwf08h4UcSyA5sz7DM6LyRMd7EJ3zjD8kr2TspN+TKKa/bIGQUFCLGQTqLdH2M+c/uQBedYdqsUAhl/S97RIYWb3cHqdZ+NH97z4SKsthJVIYqDok1dBD1B71mAnROafly+yMut4PKw+mxAyoiGzvkwx/Zekyp/Ae49NYVceIrZw== X-YMail-OSG: 4QAAkfsVM1mArbeUAt8tV2PAS.QvLAYTjy1rv9wtaJRJQ3LS6__oG5R7G5Sw2VE vnQJ3zQg0USM5cwhlW8MCtVNHfAE7QkglyMvcDYmPq5bAgYkmfNZZVcfavdh7GacAIGg6ynQIwAv lwqS6F0A4HURCnzNGQoF3_tfq2pXJQBhx8tZkK2XP3KOG.7N5CU8IcQ_eZ1qD4031xzBQdrlen84 g85P256R184CgMunX.3oWL8yz_nRoawyGWi1HgMykMEtzjTkRJDyI6SNF45_Vnt2ime3bTJMA7Mk PXEsMBYGNLBD54q2KyHjg1t_coj92EtChXtDxjSrdQepn4vnYGwe9fiOzli1QN7sCEWqQO3mN8Li 242rQQ78I4n02bDY1PVbuxVidno10G5ZaPI6HOaxkCE7NGemsfmMwu9hy9dUAU.GT.BCc8YpA6Qo 3HlZBJDkmf3n.lrxs3a6sog1kPw7xWBlLA3Saa78DradEM1KDWl0.5EphmdndFCTOfyq7UXfOX5G h4Lq92ZF__xRhHIFVOE3ejU8vPKe4LNPVRKZgCpvDh2FGuy03X4RAriRNuGwWQh0jTqHiBGxPx0U yshAhDBnYNO6a34QOq0e7ah8t_a_inoISF8RUMTii67sZvzI2mhzjWcj5fbzg15KJzjvu31C_iu8 YwEU2nSUSiOg5_6QyE.vY6yrx6Y40I5W4iGmSPCLRNVJS6Ql182.JBl6Vkf_xYjE1JQykm3rV7kB RSPGlSlYiR3hIHCQC7669TPzZxXAGj2kLpuxFleWTO9iJjZouGZyMnHZHxfgbP8uCq4m8NP7tFJA FNuBT56i8Xi6WAagpEl5bW9nHQy16_GjsI1EQAGVTzOkOa94pNGJXUdUg1K59H_otn1zaN3t_awv 67KN7QD0.CPLnF2OTFR.jK7z0WUYsTlbTpCjto3tAf1bCeNb4x5tpWCReVcYQrSGsrFytDH2.PJ_ m6Ej_TriZtsk9O_MQOYVyJVZvtC4LsEdHRMzPwEfmNuIiK6Yy2K_XVM8zHtZzqQcuZOR_gDe6lJn l9MHp0nOWOHX9GFLFyp_jF8_znX3ndau2JsTHZqYj1hEVZb0u5lQkp_BuLuv1oiyW60E_88H9Hf5 VS.r9TQY26KNDtkBpFbzVooYQAGD62huBp3ljEL1I8bSDcUxl7cwT6m.znO3AcHlfPAeziVLhMc1 zVRdH8Ihw_bNFvlWPNuyA0aGW88TpIA18IgleYjA7sN8.wIDmvLqts0UoYI_JUhLbGdMqaSlR6x4 yY0b8wuQ8o543zl9fGRiPtrauUP6WQBHY9QxNRRW.KuvetNZdHtXbWvCFDVRUDQ6EP.qstrGmPa2 Yoqfd1bCV56J93vqjAOYt4O0kBbDc1p7Q1UyGGCS0jHvDm6HVffDnfpqlsjszeLwQYGi6AN80ahM vkLWboJ2tLJqoCtTBZ5AJxvJQlskRnlIRqYEGwuhAOKOyhiu_B.rqDAaWbPjTd_fpurjQV4lsQzh D5YjpR3Fgw2QnsrTer7Y7ZZikufYbUXhnv53KoEflIFM4TltyNi1mqmlCJn1AfmH2IVU06c1i7gu dME8h7fybsBjV4XaLi2._NMMQ_MPloctAS9DtkWu0lY4p58CiK101W9CYTzpIsOp1P.qBnfH7NrL ojGGLs5VI7JP8YbQzMVf1Z3zSCbvndNIo23Q4jIzAJgvpwlneV7Zko63Fw9jJjAuSUGKHFMT0h4W KwxmvpjKwqVQRR7w5JQ4VN8FyjYTRwH6.MSoE1jUOVaifpn_5CPTDkEttlPh1xEfcqsDbflukmTz AF9qHvtRgrne.9jlsoPuHcx_oMxA8.FexIPtgGtyGNAq4zbruu6VnbHA6iWBaAoykWT9evbn4T84 k7ZWIzrAMjJ0hWInkavZj7VElZeDSwNg73FM3QaQfMVPxhD8UJsbo1KbEwx8c6dtynagm8MBqGhp qgAKXZg1hDvlVFo.SvbFmc50c9o9MXTUh9yQQ9G.D5.hGo2Z4Bjb0jnas9nedcpamm.Jz.UtlxGX QGRm6DR0ymhXm9tYZhQ80J6skNYjQPlHberPlucnp3Q7cEzIQiLh1WdNrzAYYKUXsQ_GkSVC2TMH a950TsXp0dK83218JanTEICLYN0wKMVdcKWNqkrRPSlZ9T5Fa5mg8zFpRsvmED8NBr472t_USBB4 QvDf3jPbTQfIcfiw2VkqIPmSouextXRC6D6RfdyQ0mKt_vCPjdwFagAgb0d0Yz_yY40k- X-Sonic-MF: X-Sonic-ID: 548d5761-cb2b-4a10-933e-94119236de3c Received: from sonic.gate.mail.ne1.yahoo.com by sonic313.consmr.mail.bf2.yahoo.com with HTTP; Tue, 15 Aug 2023 07:23:46 +0000 Date: Tue, 15 Aug 2023 07:23:42 +0000 (UTC) From: Jason Long To: "pgsql-general@lists.postgresql.org" Message-ID: <868525317.2467108.1692084222719@mail.yahoo.com> Subject: PostgreSQL and local HDD MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable References: <868525317.2467108.1692084222719.ref@mail.yahoo.com> X-Mailer: WebService/1.1.21695 YMailNorrin Content-Length: 283 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello, Why is the PostgreSQL database slow when it is on the server's hard drive? = My servers are HPE ProLiant DL380p G8 and=C2=A0HPE ProLiant DL380 G9. Does the database have to be on a storage like EMC or QNAP? Does PostgreSQL=C2=A0have an option to increase speed? Thank you.