Matthis H.
@sreguys
SRE / ✍️ Technical Writter https://t.co/PzZROyCjxL / Maintainer @k8sgpt
ID:1477416073880293376
https://github.com/matthisholleville 01-01-2022 23:07:08
418 Tweets
164 Followers
133 Following
If you ever try to run DROP INDEX CONCURRENTLY on #PostgreSQL and nothing happens after several minutes, check for orphaned prepared transactions.
SELECT age(transaction),* FROM pg_prepared_xacts ;
These can block VACUUM and your DROP INDEX.
cloud.google.com/sql/docs/postg…
Adding a flag on GKE Google Cloud Tech = 25 minutes wait to modify a kube system configmap! What a waste of time...