/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 www.crunchydata.com
Hacking the Postgres Statistics Tables for... | Crunchy Data Blog
| | akorotkov.github.io
ALTER INDEX ... SET STATISTICS ...? - Alexander Korotkov's blog
1.1 parsecs away

Travel
| | [AI summary] A technical deep dive into PostgreSQL's statistics gathering for indexed expressions and a workaround to improve query planning accuracy for complex expressions.
| | phiresky.github.io
Using PostgreSQL production query planner statistics to fill a mock database - phiresky's blog
3.0 parsecs away

Travel
| | Did you know that PostgreSQL stores statistics about your data that can also be pretty useful not just for the query planner? Say you have a table users (id bigint, created timestamptz, category text): This information is a bit hard to interpret, so let's just let AI give us a nice visualization of
| | jkatz.github.io
Hybrid search with PostgreSQL and pgvector | Jonathan Katz
3.2 parsecs away

Travel
| | An example of how to perform hybrid search with PostgreSQL and pgvector over vector data.
| | www.jamesserra.com
Introduction to OpenAI and LLMs - Part 2 | James Serra's Blog
23.7 parsecs away

Travel
| [AI summary] This technical blog post explains the concepts behind LLMs and Generative AI, details their architecture, and guides developers on using Azure and Microsoft Copilot Studio to apply these models to enterprise data via RAG techniques.