Re:Waiting for Postgres 16: Cumulative I/O statistics with p...
by 1500100900 on Friday February 17, 2023 @02:16PM
(#34839010)
While waiting for PG 16 you can upgrade to 15.
[ Parent
| on HN ]
Re:Waiting for Postgres 16: Cumulative I/O statistics with p...
by sgt on Friday February 17, 2023 @02:23PM
(#34839091)
Agreed. I also see PG 16 is scheduled for release later in the fall. Also, you don't want to put the first 16.0 version on a production system, rather wait until 16.1, 16.2 etc.
Re:Waiting for Postgres 16: Cumulative I/O statistics with p...
by Tostino on Friday February 17, 2023 @02:41PM
(#34839369)
That's always for the best. So now that 15 has had some time to settle, it's a good time to adopt.
Re:Waiting for Postgres 16: Cumulative I/O statistics with p...
by vlod on Friday February 17, 2023 @03:23PM
(#34840021)
Great opportunity to test your db backup process. :)
Re:Waiting for Postgres 16: Cumulative I/O statistics with p...
by macspoofing on Friday February 17, 2023 @06:17PM
(#34841920)
Because PostgreSQL major version upgrades are hard and for large databases, requires some level of downtime. Given that that major version releases are on an annual release cycle, staying evergreen is really really annoying.
Re:Waiting for Postgres 16: Cumulative I/O statistics with p...
by why-el on Friday February 17, 2023 @07:00PM
(#34842291)
Under some elementary scenarios (and using some Postgres offerings), you can do a full major upgrade using logical replication (even with replicas). It depends on your situation, generally I agree, any sophisticated use of Postgres (lot of views, materialized or not, fast changing schema, large objects, and so on) makes upgrades a pain and is generally somewhat of an unresolved problem in my opinion.