EmbeddingGemma 2: an open, lightweight multimodal embedding model
deepmind.google·6d ago
AI Engineering
Hacker News·Aug 11·5 min read
pg_clickhouse v0.10: Subquery pushdown and 1000x faster TPC-H queries
TL;DR
pg_clickhouse v0.10.0 enhances query performance by achieving full pushdown for 16 out of 22 TPC-H queries, resulting in up to 1000x faster execution times.
✦ Why It Matters
Consider upgrading to pg_clickhouse v0.10.0 to significantly enhance your query performance.
Key Takeaways
- Upgrade to pg_clickhouse v0.10 for improved query performance.
- Utilize the new binary driver for better reliability.
- Explore expanded function support for complex queries.
- Monitor remaining unoptimized queries for future updates.
How It Works
The new version of pg_clickhouse implements a mechanism that allows entire correlated subqueries to be pushed down to ClickHouse as single LEFT SEMI JOIN operations. This reduces the need for multiple round trips to the database, significantly speeding up query execution.
The binary driver has been rebuilt to enhance performance and reliability, allowing for more efficient data handling and reduced memory usage.