PostgreSQL and local HDD

From: Jason Long <hack3rcon(at)yahoo(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: PostgreSQL and local HDD
Date: 2023-08-15 07:23:42
Message-ID: 868525317.2467108.1692084222719@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
Why is the PostgreSQL database slow when it is on the server's hard drive? My servers are HPE ProLiant DL380p G8 and HPE ProLiant DL380 G9.

Does the database have to be on a storage like EMC or QNAP?

Does PostgreSQL have an option to increase speed?

Thank you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message [Quipsy] Markus Karg 2023-08-15 08:49:08 Cast INTEGER to BIT confusion
Previous Message Tom Lane 2023-08-15 03:23:15 Re: Fatal Error : Invalid Memory alloc request size 1236252631