
Optimizing queries in Postgres and BigQuery
BigQuery has no EXPLAIN. Read its execution graph and dry runs, use EXPLAIN ANALYZE in Postgres, and see how much an index speeds up a lookup.
Thank you, Singapore. See the photos from our Agentic Patterns workshop at GovTech STACK 2026.
Getting databases and warehouses to be fast, queryable, and ready for analytics.
5 articles in this topic

BigQuery has no EXPLAIN. Read its execution graph and dry runs, use EXPLAIN ANALYZE in Postgres, and see how much an index speeds up a lookup.
A general introduction to NoSQL databases and their use cases.

A detailed documentation on building a modern data warehouse in BigQuery featuring storage and performance optimization.
A discussion on full text search and indexing strategies in Postgres and BigQuery (part 2 of 2)
Filter rows on values inside a JSONB column with @>, ->> and ILIKE, and unpack nested arrays with jsonb_array_elements. Examples use real IDX company data.

A two-evening workshop on designing and shipping AI agents that do real work for your business: from the agentic patterns that keep them reliable, to a working multi-agent system that researches, drafts and reports on your behalf.
December 9, 2026Zoom Conferencing (Online)
This is one slice of the catalogue. Browse every topic on the notes index, or subscribe and we will send the next piece your way.