--- title: "Two edge cases in Postgres's full-text search" publication: "Postgres Weekly" issue: 338 published_at: "2020-01-15" canonical_url: "https://postgresweekly.com/issues/338" --- This week's Postgres news, views, and tools. #338 — January 15, 2020 [Read on the Web](https://postgresweekly.com/issues/338) 🏫 If you're in or around San Francisco or the Bay Area, consider attending [PFDay SF 2020](https://2020.pgdaysf.org/) next week. We're a sponsor and it's shaping up to be a great event :-) Postgres Weekly [How to Create, Test and Debug an Extension Written in C for Postgres](https://www.highgo.ca/2020/01/10/how-to-create-test-and-debug-an-extension-written-in-c-for-postgresql/) — Most of us aren’t ever going to build our own Postgres extensions, but it’s always good to know that we _can_. David Zhang [`PSQL_EDITOR`: Fighting with Sublime Text under Windows](https://www.cybertec-postgresql.com/en/psql_editor-fighting-with-sublime-text-under-windows/) — `PSQL_EDITOR` is a environment variable that `psql` uses to launch an external editor of your choice for certain input operations. On POSIX/Unix systems it’s pretty straight forward, but if you’re on Windows you might appreciate this article. Pavlo Golub [![\](https://copm.s3.amazonaws.com/918d7359.png)](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyP) [Real-Time Postgres Performance Monitoring](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyP) — Collect out-of-the-box and custom Postgres metrics and correlate them with data from across your distributed infrastructure and applications. Gain real-time performance insights and set intelligent alerts with Datadog. Try it free for 14-days. Datadog sponsor [Two Edge Cases in Postgres's Full-Text Search](https://jetrockets.pro/blog/two-edge-cases-in-postgresql-full-text-search) — When using `tsvector`s and `to_tsquery`, there are some quirks that could trip you up. Alexander Ivashkin and Igor Alexandrov [Installing PostGIS 3.0 and PostgreSQL 12 on CentOS 8](https://people.planetpostgresql.org/devrim/index.php?/archives/102-Installing-PostGIS-3.0-and-PostgreSQL-12-on-CentOS-8.html#centos8postgis) Devrim Gunduz [How to Build and Debug Postgres 12 using Latest Eclipse IDE on Ubuntu 18.04](https://www.highgo.ca/2020/01/10/how-to-build-and-debug-postgresql-12-using-latest-eclipse-ide-on-ubuntu-18-04/) — Another very specific guide, but if you need it, you need it :-) David Zhang ▶[Innovations to Boost Productivity with Azure-Managed Postgres](https://www.youtube.com/watch?v=qay0yZZLkJc) — One for anyone considering running Postgres (or MySQL or MariaDB) on Azure. Sunil Kamath ▶[Why Developers Love Postgres](https://www.youtube.com/watch?v=Vr6OiuIL8W8) — A just released, high level talk about why Postgres is a great database, including a section about how a department at Chevron migrated from Oracle to Postgres. Craig Kerstiens [Logical Replication in PostgreSQL](https://info.enterprisedb.com/20191218LogicalReplicationinPostgreSQL.html?utm_source=Cooperpress&utm_medium=ad) — Learn about the concept of logical replication and watch our demo on how to configure a logical replication in no time. EnterpriseDB sponsor 🔧**Tools and Code** [How To Simplify pgBouncer Monitoring with `pgbouncer_fdw`](https://info.crunchydata.com/blog/making-pgbouncer-easier-to-monitor) — In order to more easily monitor PgBouncer, the team at Crunchy Data developed an open source FDW for it. Keith Fiske [tbls: A CI-Friendly Tool for Documenting Databases](https://github.com/k1LoW/tbls) — Document a database automatically in GitHub Friendly Markdown format. By default you get documentation covering columns, indexes, relations, and other schema details. Written in Go. Ken’ichiro Oyama [Q3C: Postgres Extension for Spatial Indexing on a Sphere](https://github.com/segasai/q3c) — This is somewhat above my paygrade to understand, but it sounds like this may be particularly useful for datasets and use cases relating to sky indexing and astronomical cataloging. Sergey Koposov 🗓**Upcoming Events** - [PgDay SF](https://2020.pgdaysf.org/) (January 21 in San Francisco) — A 1-day, single-track community Postgres event. **Tickets are selling fast so get yours while you still can.** - [PgDay FOSDEM](https://2020.fosdempgday.org/) (January 31 in Brussels, Belgium) — Not only is there this Postgres event surrounding the popular open source event, but there's a Postgres room at FOSDEM itself on February 2 too. - [PgConf.Russia](https://pgconf.ru/2020) (Febuary 3-5 in Moscow, Russia) — One day of tutorials and two days of talks in three parallel sessions. - [PgConf India](https://pgconf.in/conferences/pgconfin2020) (Febuary 26-28 in Bengaluru, India) — A dedicated training day and a multi-track two-day conference. - [Nordic PgDay 2020](https://2020.nordicpgday.org/) (March 24 in Helsinki, Finland) - [pgDay Paris 2020](https://2020.pgday.paris/#%2319) (March 26 in Paris, France) — **New!** [The schedule for the event](https://www.postgresql.eu/events/pgdayparis2020/schedule/) has just been unveiled. - [Swiss PGDay 2020](http://www.pgday.ch/2020/) (June 18-19 in Switzerland) — A two track conference (one in English, one in German) aimed at the entire Postgres community. If you are running a Postgres related event that's beyond the scale of a small local meetup or user group (so, say, 50+ people with people likely to travel to your event from afar), let us know and we can include it here in future issues. 🕰 **ICYMI** _(Some older stuff that's worth checking out...)_ - Bruce Momjian shares a few [obscure Postgres tips](https://www.enterprisedb.com/blog/tips-postgres-postgres-insider) from a 'Postgres insider'. - Sebastian Insausti looks at [how to use Google Cloud Platform to store PostgreSQL backups](https://severalnines.com/database-blog/tips-storing-postgresql-backups-google-cloud-gcp) in the cloud. - Here's how to [create PostgreSQL clusters using the Kubernetes custom resource definitions](https://info.crunchydata.com/blog/creating-a-postgresql-cluster-with-kubernetes-crds) provided by the PostgreSQL Operator. - Sheshbabu Chinnakonda runs through [a quick, easy way to implement search functionality](https://dev.to/sheshbabu/minimal-viable-search-using-postgres-jlg) with PG. Curated by [Cooperpress](https://cooperpress.com/), [Peter Cooper](https://twitter.com/peterc), and [Craig Kerstiens](https://twitter.com/craigkerstiens). [Change your email address](https://postgresweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*) © Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom