--- title: "Postgres 14 release due tomorrow to fix concurrent indexing bug" publication: "Postgres Weekly" issue: 459 published_at: "2022-06-15" canonical_url: "https://postgresweekly.com/issues/459" --- Plus getting fuzzy with text matching, using schemas, and scaling IoT apps. | #​459 — June 15, 2022 [Web Version](https://postgresweekly.com/issues/459) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/zzhrk1f0an8shljgb29z.jpg)](https://blog.brendanscullion.com/postgresql-text-search) [_Fuzzy_ Text Search: From Not So Fuzzy to Fuzziest](https://blog.brendanscullion.com/postgresql-text-search) — If you’ve got free form text data supplied by other humans, it’s not going to be perfect (typos, slang, odd formatting, and the like) so supporting a little ‘fuzziness’ when querying data can go a long way. This is a nice tour through some options Postgres offers to you from least ‘fuzzy’ to full-on Fozzie Bear. Brendan Scullion ⚠️ [Imminent Postgres 14 Update to Avoid Silent Corruption of Indexes](https://www.migops.com/blog/important-postgresql-14-update-to-avoid-silent-corruption-of-indexes/) — Over on the Postgres mailing list, an important ‘out of cycle’ release [has been preannounced](https://www.postgresql.org/message-id/165473835807.573551.1512237163040609764%40wrigleys.postgresql.org) for June 16 (tomorrow) that will fix a Postgres 14 issue that can cause silent corruption of indexes if you use `CREATE INDEX CONCURRENTLY` or `REINDEX CONCURRENTLY`. There’s [a full discussion](https://www.postgresql.org/message-id/flat/17485-396609c6925b982d%40postgresql.org) on the mailing list about the problem too. Gilles Darold [![\](https://copm.s3.amazonaws.com/08546c80.jpg)](https://tsdb.co/postgres-weekly) [State of PostgreSQL 2022 Survey](https://tsdb.co/postgres-weekly) — The 2022 State of PostgreSQL survey is now open! Share your views on the PostgreSQL database, your favorite extensions, preferred frameworks, community experiences, and more. Timescale sponsor [Migrating Scheduled Jobs to `pg_timetable` From `pg_cron`](https://www.cybertec-postgresql.com/en/migrate-scheduled-jobs-to-pg_timetable-from-pg_cron/) — [pg_timetable](https://github.com/cybertec-postgresql/pg_timetable) is an advanced job scheduling extension for Postgres and offers a bit more out of the box than the less frequently updated (but still very usable) [pg_cron](https://github.com/citusdata/pg_cron). If you want to migrate at all, here’s how. Pavlo Golub [Building IoT Apps on Postgres, Citus, and Azure](https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/building-iot-apps-using-postgres-citus-and-azure/ba-p/3501175) — If you’re creating an app that handles time-series data coming from devices non-stop, scaling can quickly become an issue and leaning on managed services, such as those provided by Azure, can help keep scaling easy. Suryanarayana and Srirampur [Using Postgres Schemas](https://aaronoellis.com/articles/using-postgres-schemas) — I always struggle to describe Postgres schemas/namespaces succinctly but _“with minimal overhead, they enable segmentation and isolation of tables within a database”_ is a nice attempt. Aaron sells us on some of the benefits here. Aaron O. Ellis [What to Research When Upgrading Postgres Version](https://momjian.us/main/blogs/pgblog/2022.html#June_13_2022) — Some quick fire pointers on how to research the changes that might impact you when switching Postgres version. [Why Upgrade PostgreSQL?](https://why-upgrade.depesz.com/show?from=14.2&to=14.3) is also a handy resource. Bruce Momjian [Case-Insensitive Pattern Matching](https://www.cybertec-postgresql.com/en/case-insensitive-pattern-matching-in-postgresql/) — You may sense some echoes with the fuzzy text searching item (featured above) but Laurenz covers slightly different ground particularly around the complexity of handling case sensitivity across collations and why German’s ß keeps things interesting. Laurenz Albe [Handling Empty Strings When Migrating from Oracle to Postgres](https://aws.amazon.com/blogs/database/handle-empty-strings-when-migrating-from-oracle-to-postgresql/) — I’ve never had to migrate a database from Oracle to Postgres, but AWS is _really_ keen for you to do this and so is attempting to educate us on the problems that can arise. Pattanayak, Mahto, and Paladi (AWS) [Handling Trailing Zeros with `NUMERIC`](https://www.migops.com/blog/handling-trailing-zeros-with-numeric-datatype-in-postgresql/) — Another quirk you might run in to when doing an Oracle to Postgres migration. Jagadeesh Panuganti [Webinar on June 16th: How to Reason About Indexing Your Postgres Database](https://us02web.zoom.us/webinar/register/3416547078913/WN_cjrUDKVuSqO8GckfiCWkbA) pganalyze sponsor [Transaction Control Statements in Oracle vs Postgres](https://www.migops.com/blog/oracle-vs-postgresql-transaction-control-statements/) Akhil Reddy Banappagari [Using UUIDs to Prevent Enumeration Attacks](https://sqlfordevs.io/uuid-prevent-enumeration-attack) Tobias Petry **🔧 Code and Tools:** [pg_graphql: Bring GraphQL Support to Postgres](https://github.com/supabase/pg_graphql) — A top feature for us several months ago but not a project to be slept on. Supabase [pguint: Unsigned Integer Types Extension](https://github.com/petere/pguint) — Brings signed 8 bit integer and unsigned 8, 16, 32, and 64 bit integer types to Postgres 9.1+. Peter Eisentraut **Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). --- **Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). --- **Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. Thanks! --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. [Stop getting this newsletter.](https://postgresweekly.com/leave/*|UID|*)