Monthly Archives: July 2016

Show postgres lock

Posted on July 21, 2016 by ronaldpringadi

You’re staring at a query that won’t finish, or a deploy that hangs on a migration, or a UI request that just sits there. Postgres is almost certainly waiting on a lock that another transaction holds. The classic query for … Continue reading →

Posted in Database, PostgreSQL | Comments Off on Show postgres lock

Apache Lucene: The Search Engine Hiding Inside Half the Internet

Posted on July 21, 2016 by ronaldpringadi

If you’ve ever used Elasticsearch, Solr, or even some features in big platforms like Twitter or LinkedIn, chances are you’ve been touching Apache Lucene without knowing it. It’s the quiet workhorse — a Java library that does one thing extraordinarily … Continue reading →

Posted in java | Tagged , , | Comments Off on Apache Lucene: The Search Engine Hiding Inside Half the Internet

Check all table size in Postgres

Posted on July 12, 2016 by ronaldpringadi

You want a quick “which tables are eating my disk?” overview — usually before a vacuum, an archive purge, or a capacity-planning conversation. Here’s a one-shot query that joins information_schema.tables against pg_class to show every public table with its estimated … Continue reading →

Posted in Database, PostgreSQL | Comments Off on Check all table size in Postgres