Re: PostgreSQL and local HDD

2023-08-16 Thread Ron
On 8/16/23 03:40, Andreas Joseph Krogh wrote: På onsdag 16. august 2023 kl. 05:40:40, skrev Ron : 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.

Re: PostgreSQL and local HDD

2023-08-16 Thread Andreas Joseph Krogh
På onsdag 16. august 2023 kl. 05:40:40, skrev Ron mailto:ronljohnso...@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 CT

Re: PostgreSQL and local HDD

2023-08-15 Thread Olivier Gautherot
El mié, 16 ago 2023 6:54, Ron escribió: > On 8/15/23 23:48, Olivier Gautherot wrote: > > > El mié, 16 ago 2023 5:39, Ron 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

Re: PostgreSQL and local HDD

2023-08-15 Thread Ron
On 8/15/23 23:48, Olivier Gautherot wrote: El mié, 16 ago 2023 5:39, Ron 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 o

Re: PostgreSQL and local HDD

2023-08-15 Thread Olivier Gautherot
El mié, 16 ago 2023 5:39, Ron 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 inefficie

Re: PostgreSQL and local HDD

2023-08-15 Thread Ron
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.

Re: PostgreSQL and local HDD

2023-08-15 Thread Ron
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.

Re: PostgreSQL and local HDD

2023-08-15 Thread Olivier Gautherot
Hi Jason On Tue, Aug 15, 2023 at 9:23 AM Jason Long 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"

PostgreSQL and local HDD

2023-08-15 Thread Jason Long
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.