Overview
News
Technologies
Salaries
Products
People
Growth
Financials
Overview
Deploy enterprise-ready PostgreSQL on your choice of platform and infrastructure with commercial support from Crunchy Data.
News
Hybrid Search Patterns with Postgres and pgvector Crunchy Data Blog
Filtered vector search in Postgres forces a tradeoff between recall and speed because ANN indexes and WHERE clauses do not intersect like B-trees. Read about pgvector iterative scans, partial HNSW indexes, oversampling with pg_stats, caching, and more.
Read more
Report
Postgres 19 Compression: from pglz to LZ4 Crunchy Data Blog
With Postgres 19 switching the default from pglz to LZ4, this post walks through the compression decision path, storage strategies, and index-size limits that shape real-world behavior.
Read more
Report
British Columbia, Time Zones, and Postgres Crunchy Data Blog
This year, British Column has moved to year-round Pacific Time. How does that affect date data?
Read more
Report
The Integer at the End of the Universe: Integer Overflow in Postgres Crunchy Data Blog
Integer overflow can happen if you have a sequencing data type exceeding integer limits. Jesse has a query to help you spot it and recommendations for a short term and long term fix.
Read more
Report
Postgres Serials Should be BIGINT (and How to Migrate) Crunchy Data Blog
Postgres 18 defaults to checksums on. This is a good feature for data integrity but might catch you off guard with an upgrade.
Read more
Report
Pro access
Upgrade to see all 26 mentions
Upgrade to a paid plan to read every media mention of this company - funding news, awards, product launches and press releases from all the outlets writing about it.
Every media mention and press release
Funding news, awards and product launches
Fresh coverage from every outlet writing about the company
Upgrade now
Cancel anytime. Secure checkout. Instant activation.