I finished a large chunk on improving the enhanced @PostgreSQL driver for @laravelphp. The new version has a lot of new indexing functionality to make your database queries really fast and use all the power of PostgreSQL 🔥
👇 All new features explained one-by-one
With partial indexes you can limit an index to only handle specific rows to build smaller indexes or even do things you couldn't do before. You can e.g. make the email address now unique by ignoring duplicate values in soft-deleted rows.
You can add columns to the index which are not used for lookups but can be used to get the most efficient type of lookups a database can do: index-only lookups and index-only scans.
Sometimes the storage parameters need to be tuned for some optimizations. You should read about gin indexes for e.g. wildcard search [1] or jsonb and then understand why you have to change the storage parameters [2]
The amount of new features EVERY YEAR is incredible and there are again many nice features greatly improving your daily life. Most important this year is JSONB!
👇 Keep reading for an overview of the most important features.
👉Improved JSONB
If you never stored any JSON content in your tables you are definitely missing out on some very great features of PostgreSQL. From now on, you can use an improved syntax with much simpler support for updating nested values. postgresql.org/docs/14/dataty…
👉Multirange Types
Range Types have always been a fantastic feature of PostgreSQL and I totally fell in love with them. You can now store multiple ranges within one column and use the extensive range operators for querying.