When changing glibc versions, it's possible to end up with corrupt indexes in PostgreSQL. Are My Indexes Affected?
When changing the glibc version, it's possible that the upgrade also includes changes to how locales work.
Best results in other decks
When debugging slow SQL queries, it’s helpful to understand the database engine's query plan. Whenever you execute a...
This is a small example on how you can check if your Postgres index can be used by a specific query in you Rails application. For more complex execution plans...