Raise minimum PostgreSQL version to 12

Oneric commented

2024-05-30 23:58:56 +00:00

Member

PostgreSQL 11 is EOL since 2023-11-09.
Dropping it lets us simplify search code a bit and avoids the hash index problem for PSQL<10 brought up in #765.

PostgreSQL 11 is EOL [since 2023-11-09](https://www.postgresql.org/support/versioning/). Dropping it lets us simplify search code a bit and avoids the hash index problem for PSQL<10 brought up in #765.

norm commented

2024-05-31 06:21:05 +00:00

Contributor

Might as well raise the minimum to 12 (which still seems to be supported until 2024-11-14) so that we can have this option enabled by default: https://docs.akkoma.dev/stable/configuration/postgresql/#disable-generic-query-plans

floatingghost commented

2024-05-31 14:13:49 +00:00

Owner

honestly yeah, even debian oldstable is pgsql 13 - we can push to that just fine i think

Oneric changed title from ~~Raise minimum PostgreSQL version to 11~~ to Raise minimum PostgreSQL version to 12

2024-05-31 15:07:15 +00:00

Oneric force-pushed psql-min-ver from 610a138845 to 95531eca68

2024-05-31 15:11:54 +00:00

Compare

Oneric commented

2024-05-31 15:12:33 +00:00

Author

Member

Neat, didn’t know about that option. Now bumping to 12 and setting the custom plan option; since startup fails with an illegal value, it seems like it does take effect.

Does bumping to 13 enable anything further? I only know of 12’s query planer sometimes producing worse results but nothing which holds newer versions back (in the linked case, things are already supposed to work without using a cross join anyway)

Neat, didn’t know about that option. Now bumping to 12 and setting the custom plan option; since startup fails with an illegal value, it seems like it does take effect. Does bumping to 13 enable anything further? I only know of 12’s query planer [sometimes producing worse results](https://akkoma.dev/AkkomaGang/akkoma/issues/650#issuecomment-11931) but nothing which holds newer versions back *(in the linked case, things are already _supposed_ to work without using a cross join anyway)*

norm commented

2024-06-02 20:32:19 +00:00

Contributor

13 seems to mostly contain performance improvements and better query planning, but otherwise I don't really think there's something that seems to stand out in terms of features that would greatly benefit Akkoma.
https://www.postgresql.org/docs/13/release-13.html

Bumping to 13 would mean those that are still running Ubuntu 20.04 would need to upgrade or switch to another repo since it has Postgres 12 in the default repos, but I don't really know how many people still use it with Akkoma.

13 seems to mostly contain performance improvements and better query planning, but otherwise I don't really think there's something that seems to stand out in terms of features that would greatly benefit Akkoma. https://www.postgresql.org/docs/13/release-13.html Bumping to 13 would mean those that are still running Ubuntu 20.04 would need to upgrade or switch to another repo since it has Postgres 12 in the default repos, but I don't really know how many people still use it with Akkoma.

floatingghost commented

2024-06-07 13:00:08 +00:00

Owner

heh ok merge conflicto, hooray

Oneric force-pushed psql-min-ver from 95531eca68 to b405229612

2024-06-07 13:56:34 +00:00

Compare

Oneric commented

2024-06-07 13:57:38 +00:00

Author

Member

rebased