pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PostgreSQL and local HDD
9+ messages / 4 participants
[nested] [flat]

* PostgreSQL and local HDD
@ 2023-08-15 07:23  Jason Long <hack3rcon@yahoo.com>
  0 siblings, 2 replies; 9+ messages in thread

From: Jason Long @ 2023-08-15 07:23 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>

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.





^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: PostgreSQL and local HDD
@ 2023-08-15 09:24  Olivier Gautherot <ogautherot@gautherot.net>
  parent: Jason Long <hack3rcon@yahoo.com>
  1 sibling, 1 reply; 9+ messages in thread

From: Olivier Gautherot @ 2023-08-15 09:24 UTC (permalink / raw)
  To: Jason Long <hack3rcon@yahoo.com>; +Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>

Hi Jason

On Tue, Aug 15, 2023 at 9:23 AM Jason Long <hack3rcon@yahoo.com> wrote:

> 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.
>

Can you be more specific in your question? Reasons for the server would be
"slow" can be many and can be addressed in many ways. So additional
information would be welcome:
- Size of the database
- Number of rows (and their number of columns, size...) in the tables
- Indices and other optimization tricks
- The query itself
- ... and other server configuration parameters

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

Faster storage can only help but I would start by discarding functional
overhead.

Does PostgreSQL have an option to increase speed?
>

It is usually achieved by reducing the number of rows you pull from the
disk.
Try the command EXPLAIN (
https://www.postgresql.org/docs/current/sql-explain.html )  to see where
the server is wasting time.


> Thank you.
>

--
Olivier Gautherot

^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: PostgreSQL and local HDD
@ 2023-08-16 03:39  Ron <ronljohnsonjr@gmail.com>
  parent: Olivier Gautherot <ogautherot@gautherot.net>
  0 siblings, 1 reply; 9+ messages in thread

From: Ron @ 2023-08-16 03:39 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

On 8/15/23 04:24, Olivier Gautherot wrote:
[snip]
>
>     Does the database have to be on a storage like EMC or QNAP?
>
>
> Faster storage can only help but I would start by discarding functional 
> overhead.

Functional overhead?

-- 
Born in Arizona, moved to Babylonia.

^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: PostgreSQL and local HDD
@ 2023-08-16 03:40  Ron <ronljohnsonjr@gmail.com>
  parent: Jason Long <hack3rcon@yahoo.com>
  1 sibling, 1 reply; 9+ messages in thread

From: Ron @ 2023-08-16 03:40 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

On 8/15/23 02:23, Jason Long wrote:
[snip]
> Does PostgreSQL have an option to increase speed?

Like a Turbo button?

-- 
Born in Arizona, moved to Babylonia.





^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: PostgreSQL and local HDD
@ 2023-08-16 04:48  Olivier Gautherot <ogautherot@gautherot.net>
  parent: Ron <ronljohnsonjr@gmail.com>
  0 siblings, 1 reply; 9+ messages in thread

From: Olivier Gautherot @ 2023-08-16 04:48 UTC (permalink / raw)
  To: Ron <ronljohnsonjr@gmail.com>; +Cc: PostgreSQL General <pgsql-general@lists.postgresql.org>

El mié, 16 ago 2023 5:39, Ron <ronljohnsonjr@gmail.com> escribió:

> On 8/15/23 04:24, Olivier Gautherot wrote:
>
> [snip]
>
> Does the database have to be on a storage like EMC or QNAP?
>>
>
> Faster storage can only help but I would start by discarding functional
> overhead.
>
>
> Functional overhead?
>

I mean inefficient design, which won't be solved by changing the storage.

--
Olivier Gautherot

>
>

^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: PostgreSQL and local HDD
@ 2023-08-16 04:54  Ron <ronljohnsonjr@gmail.com>
  parent: Olivier Gautherot <ogautherot@gautherot.net>
  0 siblings, 1 reply; 9+ messages in thread

From: Ron @ 2023-08-16 04:54 UTC (permalink / raw)
  To: PostgreSQL General <pgsql-general@lists.postgresql.org>

On 8/15/23 23:48, Olivier Gautherot wrote:
>
> El mié, 16 ago 2023 5:39, Ron <ronljohnsonjr@gmail.com> escribió:
>
>     On 8/15/23 04:24, Olivier Gautherot wrote:
>     [snip]
>>
>>         Does the database have to be on a storage like EMC or QNAP?
>>
>>
>>     Faster storage can only help but I would start by discarding
>>     functional overhead.
>
>     Functional overhead?
>
>
> I mean inefficient design, which won't be solved by changing the storage.

Ah, the normal aspects of physical design...

-- 
Born in Arizona, moved to Babylonia.

^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: PostgreSQL and local HDD
@ 2023-08-16 06:12  Olivier Gautherot <ogautherot@gautherot.net>
  parent: Ron <ronljohnsonjr@gmail.com>
  0 siblings, 0 replies; 9+ messages in thread

From: Olivier Gautherot @ 2023-08-16 06:12 UTC (permalink / raw)
  To: Ron <ronljohnsonjr@gmail.com>; +Cc: PostgreSQL General <pgsql-general@lists.postgresql.org>

El mié, 16 ago 2023 6:54, Ron <ronljohnsonjr@gmail.com> escribió:

> On 8/15/23 23:48, Olivier Gautherot wrote:
>
>
> El mié, 16 ago 2023 5:39, Ron <ronljohnsonjr@gmail.com> escribió:
>
>> On 8/15/23 04:24, Olivier Gautherot wrote:
>>
>> [snip]
>>
>> Does the database have to be on a storage like EMC or QNAP?
>>>
>>
>> Faster storage can only help but I would start by discarding functional
>> overhead.
>>
>>
>> Functional overhead?
>>
>
> I mean inefficient design, which won't be solved by changing the storage.
>
>
> Ah, the normal aspects of physical design...
>

... and considerung that the OP did not quantify what "slow" means and what
his reference/expectation is.

Let's wait for the OP to give more background.

>

^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: PostgreSQL and local HDD
@ 2023-08-16 08:40  Andreas Joseph Krogh <andreas@visena.com>
  parent: Ron <ronljohnsonjr@gmail.com>
  0 siblings, 1 reply; 9+ messages in thread

From: Andreas Joseph Krogh @ 2023-08-16 08:40 UTC (permalink / raw)
  To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-general@lists.postgresql.org



På onsdag 16. august 2023 kl. 05:40:40, skrev Ron <ronljohnsonjr@gmail.com 
<mailto:ronljohnsonjr@gmail.com>>:
On 8/15/23 02:23, Jason Long wrote:
[snip]
> Does PostgreSQL have an option to increase speed?

Like a Turbo button?
It actually has that, but you'll have to sacrifice some safety.






--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas@visena.com <mailto:andreas@visena.com>
www.visena.com <https://www.visena.com;
 <https://www.visena.com;

^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: PostgreSQL and local HDD
@ 2023-08-16 14:25  Ron <ronljohnsonjr@gmail.com>
  parent: Andreas Joseph Krogh <andreas@visena.com>
  0 siblings, 0 replies; 9+ messages in thread

From: Ron @ 2023-08-16 14:25 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

On 8/16/23 03:40, Andreas Joseph Krogh wrote:
> På onsdag 16. august 2023 kl. 05:40:40, skrev Ron <ronljohnsonjr@gmail.com>:
>
>     On 8/15/23 02:23, Jason Long wrote:
>     [snip]
>     > Does PostgreSQL have an option to increase speed?
>
>     Like a Turbo button?
>
> It actually has that, but you'll have to sacrifice some safety.
>

lol... we /never/ push /that/ turbo button.

-- 
Born in Arizona, moved to Babylonia.

^ permalink  raw  reply  [nested|flat] 9+ messages in thread


end of thread, other threads:[~2023-08-16 14:25 UTC | newest]

Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-08-15 07:23 PostgreSQL and local HDD Jason Long <hack3rcon@yahoo.com>
2023-08-15 09:24 ` Olivier Gautherot <ogautherot@gautherot.net>
2023-08-16 03:39   ` Ron <ronljohnsonjr@gmail.com>
2023-08-16 04:48     ` Olivier Gautherot <ogautherot@gautherot.net>
2023-08-16 04:54       ` Ron <ronljohnsonjr@gmail.com>
2023-08-16 06:12         ` Olivier Gautherot <ogautherot@gautherot.net>
2023-08-16 03:40 ` Ron <ronljohnsonjr@gmail.com>
2023-08-16 08:40   ` Andreas Joseph Krogh <andreas@visena.com>
2023-08-16 14:25     ` Ron <ronljohnsonjr@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox