1

I'm using Azure Postgres flexible server and now I want to implement table partition by several values in a column. I went through pg_partmen(v4.7.1) extension docs and seems it doesn't support list partitioning.

Versions I'm using,

  • Postgres: v15
  • pg_partman: v4.7.1 (This is the version Azure currently supports)

Use-case: Assume there is a Postgres table called "Employee" like below and want to implement partition by country. Currently the Employee table is having millions of records and I want to improve the performance.

Employee Table

employee_id first_name last_name email country
1 John Doe [email protected] USA
2 Jane Smith [email protected] Canada
3 Michael Johnson [email protected] UK
4 Emily Brown [email protected] Australia

How can I achieve that on Azure Postgres flexible server?

Improve this question
0
Related questions
1
Azure Postgres Flexible Server - Vnet integration DNS not resolving
1
Azure postgres flexible server create user using terraform
0
Terraform obtain IP of azure postgres flexible server
Load 3 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.