Use newer version of Postgres for Optimize performance tests

[RomanJRW]

Acceptance Criteria (Required on creation)

Optimize runs its performance CI tests against an Engine with a Postgres version that is not in extended support

Hints

As per the conversation in this thread, Optimize is currently running its nightly performance tests against a provisioned Postgres instance using version 9. This version will soon go into extended support (in 2025), and incur higher costs.

Optimize should update to a newer version of Postgres with the connected engine. Note that the Postgres client is already the latest version, and the use of postgres is limited to storing engine data. It is expected to be a relatively straightforward migration with respect to breaking changes.

We first need to verify that these tests are successful when running against a new version of Postgres, then can update the version being used in GCP.

Links

• Slack conversation
• Postgress support/release dates

Breakdown

Pull Requests

Beta Give feedback

No tasks being tracked yet.

Dev2QA handover

• Does this ticket need a QA test and the testing goals are not clear from the description? Add a Dev2QA handover comment

[yanavasileva]

I am interested to work on this. And as far as I understand the priority is low.

[clementnero]

I am interested to work on this. And as far as I understand the priority is low.

Yes, this is not urgent as the final deprecation of PostgreSQL 9.6 is scheduled for 2028, but costs will increase between now and then.

When the newer version of PostgreSQL is chosen/known , please contact us so we can plan the migration on our end (or simply create a new ticket with a due date).