Post gre sql database

Question

Post gre sql database

ReCloudS 80

Hello ,

we have post gre sql for database and we have been using n8n container is using Postgres as a metadata storage and the storage is getting full by every week .. is there any way we can delete or free up space in azure portal for the postgre sql database ?

Accepted answer

0 additional answers

Your answer

Answer 1

GeethaThatipatri-MSFT 29,542 Microsoft Employee Moderator

@ReCloudS Welcome to the Microsoft Q&A forum, Thanks for posting your question.

To free up space in your Azure Database for PostgreSQL from the Azure portal, you can scale up the storage tier of your server. You can do this by selecting your server in the Azure portal, selecting Pricing tier, located in the Settings section, and changing the Storage setting.

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-scale-compute-storage-portal

You can also identify and remove any data that is no longer needed, such as old records, logs, or temporary data. However, before deleting any data, it is important to take a backup to ensure that you can restore the data if needed and delete data, you can use SQL commands to remove rows from tables or drop tables entirely if no longer needed.

Additionally, you can optimize your database by running the VACUUM command, using the ANALYZE command, or using the pg_repack extension to reorganize tables and indexes to reduce storage usage. However, these options would need to be executed using a tool such as psql or Azure CLI

psql -h <server_name>.postgres.database.azure.com -U <username>@<server_name> -d <database_name> -p 5432 -W

VACUUM FULL my_table;

Please let me know if you need any additional information.

Regards

Geetha

ReCloudS 80 Reputation points

2023-05-22T15:52:14.5566667+00:00

Thank you Geetha Thatipatri , I have already increased the storage space in the azure portal because it keeps on increasing every week and that costs us . I want to auto clear the storage space .Is there anything we can do it in azure portal or anything in the post gre sql database? And could you please elaborate on the above answer like how can I achieve it by logging into the server or can you please provide me the Microsoft document , that would be helpful. Thanks
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2023-05-22T16:36:36.4266667+00:00

@ReCloudS you need to check first the table bloat to see where the increases are coming from, do some tuning for performance but if you are loading large data sets the tables will grow and use more space. also, backups will grow

I would suggest checking these documents vacuum full will rebuild the tables and views, therefore, reducing storage use.

PostgreSQL: Documentation: 15: VACUUM and https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-autovacuum-tuning

You can't log in to the server. you can manage it from the portal, changing configs. restart, backup,...etc, and changing SKU

Regards

Geetha
ReCloudS 80 Reputation points

2023-05-22T18:09:01.95+00:00

Thank you Geetha will

look into it .
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator

2023-05-22T18:49:47.63+00:00

Thank you for visiting the Microsoft QA forums! Have a great day!

Share via

Post gre sql database

0 additional answers

Your answer