[Evergreen-dev] Evergreen 3.14 - Remove support for PostgreSQL 10 (and 11 and 12) ?

[Jason Stephenson]

Hi, all.

I think we should set the minimum version of PostgreSQL required for 
Evergreen 3.14 to PostgreSQL 13. This is me speaking as a member of the 
3.14 release team, and as the person who usually works on adding 
installation support for new PostgreSQL releases in Evergreen.

According to the PostgreSQL versioning policy, Pg 10 & 11 are out of 
community support, and Pg 12 community support ends on November 14, 2024.

See https://www.postgresql.org/support/versioning/


I think that continuing to support obsolete database versions is holding 
us back, and many of the optimization tricks we've added for those older 
releases would no longer be needed. In my testing on the same hardware 
an unoptimized PostgreSQL 16 database is generally faster than an 
optimized PostgreSQL 10 database. This is with production data, but not 
a production work load.

Just my, $2.00 (inflation),
Jason Stephenson