Check API: Upgrade PostgreSQL and use its native partitioning feature

[caiosba]

Tell us about your request

Upgrade PostgreSQL version on Check API so its native partitioning feature can be used.

Which service(s) is this request for?

Check API.

Tell us about the problem you're trying to solve. What are you trying to do, and why is it hard?

The latest version of PostgreSQL provides a much better and native partitioning feature, and it can replace the current partitioning feature in Check API, which is not very elegant neither scalable.

Are you currently working around the issue?

We currently use a gem for the partitioning feature, called partitioned.

Additional context

We're having performance issues with the current versions partitions in the current PostgreSQL version.