pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL and local HDD
9+ messages / 4 participants
[nested] [flat]
* PostgreSQL and local HDD
@ 2023-08-15 07:23 Jason Long <hack3rcon@yahoo.com>
2023-08-15 09:24 ` Re: PostgreSQL and local HDD Olivier Gautherot <ogautherot@gautherot.net>
2023-08-16 03:40 ` Re: PostgreSQL and local HDD Ron <ronljohnsonjr@gmail.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 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 ` Re: PostgreSQL and local HDD Ron <ronljohnsonjr@gmail.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-15 07:23 PostgreSQL and local HDD Jason Long <hack3rcon@yahoo.com>
2023-08-15 09:24 ` Re: PostgreSQL and local HDD Olivier Gautherot <ogautherot@gautherot.net>
@ 2023-08-16 03:39 ` Ron <ronljohnsonjr@gmail.com>
2023-08-16 04:48 ` Re: PostgreSQL and local HDD 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-15 07:23 PostgreSQL and local HDD Jason Long <hack3rcon@yahoo.com>
2023-08-15 09:24 ` Re: PostgreSQL and local HDD Olivier Gautherot <ogautherot@gautherot.net>
2023-08-16 03:39 ` Re: PostgreSQL and local HDD Ron <ronljohnsonjr@gmail.com>
@ 2023-08-16 04:48 ` Olivier Gautherot <ogautherot@gautherot.net>
2023-08-16 04:54 ` Re: PostgreSQL and local HDD 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-15 07:23 PostgreSQL and local HDD Jason Long <hack3rcon@yahoo.com>
2023-08-15 09:24 ` Re: PostgreSQL and local HDD Olivier Gautherot <ogautherot@gautherot.net>
2023-08-16 03:39 ` Re: PostgreSQL and local HDD Ron <ronljohnsonjr@gmail.com>
2023-08-16 04:48 ` Re: PostgreSQL and local HDD Olivier Gautherot <ogautherot@gautherot.net>
@ 2023-08-16 04:54 ` Ron <ronljohnsonjr@gmail.com>
2023-08-16 06:12 ` Re: PostgreSQL and local HDD 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-15 07:23 PostgreSQL and local HDD Jason Long <hack3rcon@yahoo.com>
2023-08-15 09:24 ` Re: PostgreSQL and local HDD Olivier Gautherot <ogautherot@gautherot.net>
2023-08-16 03:39 ` Re: PostgreSQL and local HDD Ron <ronljohnsonjr@gmail.com>
2023-08-16 04:48 ` Re: PostgreSQL and local HDD Olivier Gautherot <ogautherot@gautherot.net>
2023-08-16 04:54 ` Re: PostgreSQL and local HDD Ron <ronljohnsonjr@gmail.com>
@ 2023-08-16 06:12 ` Olivier Gautherot <ogautherot@gautherot.net>
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-15 07:23 PostgreSQL and local HDD Jason Long <hack3rcon@yahoo.com>
@ 2023-08-16 03:40 ` Ron <ronljohnsonjr@gmail.com>
2023-08-16 08:40 ` Re: PostgreSQL and local HDD Andreas Joseph Krogh <andreas@visena.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-15 07:23 PostgreSQL and local HDD Jason Long <hack3rcon@yahoo.com>
2023-08-16 03:40 ` Re: PostgreSQL and local HDD Ron <ronljohnsonjr@gmail.com>
@ 2023-08-16 08:40 ` Andreas Joseph Krogh <andreas@visena.com>
2023-08-16 14:25 ` Re: PostgreSQL and local HDD 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-15 07:23 PostgreSQL and local HDD Jason Long <hack3rcon@yahoo.com>
2023-08-16 03:40 ` Re: PostgreSQL and local HDD Ron <ronljohnsonjr@gmail.com>
2023-08-16 08:40 ` Re: PostgreSQL and local HDD Andreas Joseph Krogh <andreas@visena.com>
@ 2023-08-16 14:25 ` Ron <ronljohnsonjr@gmail.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