A Smooth Sea Never Made a Skillful Sailor

This is my series of articles covering short "Today I learned" topics as I work with CockroachDB. Today, we're finding partial indexes, identifying the DB Console URL with SQL, experimenting with a light weight pooler called pgcat , handling client disconnects and improving UX with PGSERVICEFILE Previous articles Volume 1 Volume 2 Volume 3 Volume 4 Volume 5 Volume 6 Volume 7 Volume 8 Volume 9 Volume 10 Volume 11 Topics Topic 1: Identify partial indexes Topic 2: Capture the DB Console URL with SQL Topic 3: Experimenting with pgcat Topic 4: CockroachDB and pgbench client disconnects Topic 5: CockroachDB and PGSERVICEFILE Topic 1: Identify partial indexes Our engineering team has issued a technical advisory #96924 where certain schema changes like dropping columns referenced in partial indexes will fail. A customer asks how to identify databases, tables and the associated partial indexes referencing columns to be dropped. The following meth...