Postgres on Nimble

Dataguy1 — Thu, 18 Jun 2020 21:07:19 GMT

Hi,

I am running an AF60 All Flash nimble array with centos VM's on VMWare 6.7. We have SQL Server VMs running using the recommendations (drive layout, performance profiles etc) from the document below

- HPE NImble Storage Deployment Considerations for MSSQL Server (May 2017)

We are now setting up a Postgres cluster running on Centos and are looking for a similar document from Nimble. Does one exist please?

My thoughts\experience are that most database solutions run well with an 8kb blocksize and that the "SQL Server Data Performance Profile" and "SQL Server Log Performance Profile" could be a good starting point for Postgres (in preference to the standard Nimble profile).

But we are really looking for a recommendation from Nimble. Are there are any recommendations for performance profiles for Postgres?

Many thanks

Re: Postgres on Nimble

Nick_Dyer — Fri, 19 Jun 2020 08:38:47 GMT

Hi, good day.

We don't have a formal deployment considerations guide for Postgres SQL, but that being said - databases function at 8kb block sizes by design.

Referring to this site, it notes that with Postgres you can define the DB block size on creation. The default is most likely 8k, but you can change if you want. I personally wouldn't and keep at 8kb. The log files will be 4kb.

I personally would create a new performance policy for Postgres with 8kb blocks, cache/compression/dedupe on and be done with it

topic Re: Postgres on Nimble in HPE Nimble Storage Solution Specialists

Postgres on Nimble

Re: Postgres on Nimble