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"