Re:PostgreSQL 14
by darksaints on Thursday September 30, 2021 @11:11AM
(#28707272)
I know this isn't even a big enough deal to mention in the news release, but I am massively excited about the new multirange data types. I work with spectrum licensing and range data types are a godsend (for representing spectrum ranges that spectrum licenses grant). However, there are so many scenarios where you want to treat multiple ranges like a single entity (say, for example, an uplink channel and a downlink channel in an FDD band). And there are certain operations like range differences (e.g. '[10,100)' - '[50,60)'), that aren't possible without multirange support. For this, I am incredibly grateful.
Also great is the parallel query support for materialized views, connection scalability, query pipelining, and jsonb accessor syntax.
Re:PostgreSQL 14
by jkatz05 on Thursday September 30, 2021 @11:16AM
(#28707330)
Multiranges are one of the lead items in the news release :) I do agree that they are incredibly helpful and will help to reduce the complexity of working with ranges.
Also great is the parallel query support for materialized views, connection scalability, query pipelining, and jsonb accessor syntax.