Обсуждение: PostgreSQL on netapp AFF C250A storage ?
Hello All Has anyone run PostgreSQL on netapp AFF C250A storage ? Have you run into any problems regarding reliability or performance ? Thank you
We have used the MSSQL with NetApp storage. We didn't face any issues.
On Fri, 10 May, 2024, 17:01 Achilleas Mantzios - cloud, <a.mantzios@cloud.gatewaynet.com> wrote:
Hello All
Has anyone run PostgreSQL on netapp AFF C250A storage ? Have you run
into any problems regarding reliability or performance ?
Thank you
On 5/10/24 14:35, Srinivasarao Oguri wrote:
Thank you!We have used the MSSQL with NetApp storage. We didn't face any issues.
On Fri, 10 May, 2024, 17:01 Achilleas Mantzios - cloud, <a.mantzios@cloud.gatewaynet.com> wrote:Hello All
Has anyone run PostgreSQL on netapp AFF C250A storage ? Have you run
into any problems regarding reliability or performance ?
Thank you
Στις 10/5/24 14:30, ο/η Achilleas Mantzios - cloud έγραψε: > Hello All > > Has anyone run PostgreSQL on netapp AFF C250A storage ? Have you run > into any problems regarding reliability or performance ? > > Thank you > Just to make our situation more clear, we are thinking about moving from cloud to premise again, for the moment this is just a long term vision. So nothing is cemented, but we have purchased a couple of those systems already so I'd like to know your general experience with running PostgreSQL on netapp AFF. Or maybe recommend something else. I am the same guy who had sent this message 9 years earlier : https://www.postgresql.org/message-id/flat/5502C98F.2090806%40matrix.gatewaynet.com Then in summer 2016 while on vacations I lost the WAL disk. > > > -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt (as agents only)
On Sat, May 11, 2024 at 4:24 AM Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com> wrote:
Στις 10/5/24 14:30, ο/η Achilleas Mantzios - cloud έγραψε:
> Hello All
>
> Has anyone run PostgreSQL on netapp AFF C250A storage ? Have you run
> into any problems regarding reliability or performance ?
>
> Thank you
>
Just to make our situation more clear, we are thinking about moving from
cloud to premise again, for the moment this is just a long term vision.
So nothing is cemented, but we have purchased a couple of those systems
already so I'd like to know your general experience with running
PostgreSQL on netapp AFF.
Or maybe recommend something else.
I am the same guy who had sent this message 9 years earlier :
https://www.postgresql.org/message-id/flat/5502C98F.2090806%40matrix.gatewaynet.com
Then in summer 2016 while on vacations I lost the WAL disk.
Backups... take them early, take them often, and make sure they restore properly. Then you can run on cheaper hardware with some confidence that all your data will still be there.
I'm a big fan of PgBackRest. Our infrastructure is (so far) reliable, and Postgresql is (so far) too, so I've never had to do a crash recovery, but the applications or users occasionally break something, and then it's OMG WE MUST RESTORE THE DATABASE NOW!!! PgBR's continuous and integrated PITR has always worked perfectly for us.
Στις 11/5/24 16:05, ο/η Ron Johnson έγραψε:
thank you Ron, we run PgSQL since 2001, my question was strictly on this vendor / model.On Sat, May 11, 2024 at 4:24 AM Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com> wrote:Στις 10/5/24 14:30, ο/η Achilleas Mantzios - cloud έγραψε:
> Hello All
>
> Has anyone run PostgreSQL on netapp AFF C250A storage ? Have you run
> into any problems regarding reliability or performance ?
>
> Thank you
>
Just to make our situation more clear, we are thinking about moving from
cloud to premise again, for the moment this is just a long term vision.
So nothing is cemented, but we have purchased a couple of those systems
already so I'd like to know your general experience with running
PostgreSQL on netapp AFF.
Or maybe recommend something else.
I am the same guy who had sent this message 9 years earlier :
https://www.postgresql.org/message-id/flat/5502C98F.2090806%40matrix.gatewaynet.com
Then in summer 2016 while on vacations I lost the WAL disk.Backups... take them early, take them often, and make sure they restore properly. Then you can run on cheaper hardware with some confidence that all your data will still be there.I'm a big fan of PgBackRest. Our infrastructure is (so far) reliable, and Postgresql is (so far) too, so I've never had to do a crash recovery, but the applications or users occasionally break something, and then it's OMG WE MUST RESTORE THE DATABASE NOW!!! PgBR's continuous and integrated PITR has always worked perfectly for us.
-- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt (as agents only)