PostgreSQL Storage cost

[amel_saidani]

Hello,

In the cost estimator for PostgreSQL , storage metrics : the cost is per 5gb blocks.

So when we estimate a 100GB expected size, we would calculate 20blocks.

But when we analyze the costs of this application in the cockpit, only 1 block for storage is found to be consumed. 

How is this calculated ? Can you please help understand how this storage is actually calculated ?

Thank you 

[Ivan-Mirisola]

Hi @amel_saidani ,

Try updating the storage on the instance by issuing the following command:

cf update-service <my-pg-instance-standard> -c 
‘{  
	“memory”: 4, 
	“storage”: 50
}’

Or use the update function of the instance in the cockpit using the complete JSON configuration.

{
    "engine_version": "15",
    "locale": "en_US",
    "storage": "50",
    "memory": "4"
}

NOTE: Check the following documentation for the available options while updating and instance:

https://help.sap.com/docs/postgresql-hyperscaler-option/postgresql-on-sap-btp-hyperscaler-option/pro...

When you create a new instance of PostgreSQL Hyperscaler Option, all you set on the creation wizard is the engine version and locale while using the "Form" as option. However, there is the advanced option on tab "JSON" where you can enter all parameters used for the instance creation. These options are documented here:

https://help.sap.com/docs/postgresql-hyperscaler-option/postgresql-on-sap-btp-hyperscaler-option/par...

Looking the the storage parameter you will see that it has to be a multiple of 5 and the broker will round it up to the next multiple of 5. And you can clearly see that the default value is 5Gb when not informed.

Therefore, when you created it the first time, you probably haven't chosen the "Advanced" option that uses the JSON to send the parameters to the BTP instance broker. Hence, the instance got created with the default value of 5.

Best regards,
Ivan