optimization

PostgreSQL BM25 Full-Text Search: Speed Up Performance With These Tips

, ,

PostgreSQL Full-Text Search (FTS) can outperform dedicated search engines when optimized correctly. A benchmark showed significant speeds, with optimizations yielding a ~50x performance increase by pre-calculating and storing the tsvector, and configuring GIN indexes properly. Common pitfalls include calculating tsvector on-the-fly and using the default GIN index setting (fastupdate=on), which hinders performance. For advanced ranking tasks, the VectorChord-BM25 extension may be required, offering better relevance scoring than standard methods. Optimal configurations reveal that standard FTS is faster than often perceived.

https://blog.vectorchord.ai/postgresql-full-text-search-fast-when-done-right-debunking-the-slow-myth

You Can Make Postgres Scale

,

Postgres can scale, despite controversy. Challenges include hardware needs and write capacity issues often due to lock contention or idle transactions. A community effort successfully implemented sharding to balance and increase write workloads across multiple databases, aligning with the engineering principle of solving problems fundamentally. The process involved complex steps like synchronizing data and rewriting codes. Ultimately, they created a scalable setup with 36 databases and a tool, PgDog, to automate future scaling. The project aims to demonstrate that Postgres can effectively scale as needed.

https://pgdog.dev/blog/you-can-make-postgres-scale

How to Make Web Videos Way Smaller in 2025 Using the AV1 codec—Martian Chronicles, Evil Martians’ Team Blog

,

AV1 codec enables significantly smaller web video files (20-40x) while maintaining quality. Supported by major browsers, it excels at low bitrate compression. Users are encouraged to transition from GIFs to AV1 or H.264 for better efficiency. To optimize compatibility, accommodating both AV1 and H.264 formats is recommended, using FFmpeg for encoding. This approach enhances loading times and viewing experiences across devices, balancing quality and file size effectively.

https://evilmartians.com/chronicles/better-web-video-with-av1-codec

VectorChord-BM25: Revolutionize PostgreSQL Search With BM25 Ranking

, ,

VectorChord-BM25 enhances PostgreSQL full-text search via BM25 ranking, outperforming ElasticSearch in speed (3x faster) while maintaining accuracy. Key features include optimized indexing, enhanced tokenization, and relevant scoring, making it ideal for various applications. The implementation focuses on integrating BM25 scoring natively in PostgreSQL, contrasting with other solutions like ParadeDB, which may face compatibility issues. Future developments aim to enhance tokenization for better multilingual support. Overall, VectorChord-BM25 sets a new standard for efficient, relevance-based searches in PostgreSQL.

https://blog.vectorchord.ai/vectorchord-bm25-revolutionize-postgresql-search-with-bm25-ranking-3x-faster-than-elasticsearch

Why Are QR Codes With Capital Letters Smaller Than QR Codes With Lower-case Letters?

QR codes with capital letters are smaller than those with lowercase letters because uppercase codes use Alphanumeric mode, which is more efficient, requiring fewer bits per character (11 bits for two characters) compared to Byte mode used by lowercase (8 bits per character). For the same URL, this results in less data, hence a smaller QR code.

https://shkspr.mobi/blog/2025/02/why-are-qr-codes-with-capital-letters-smaller-than-qr-codes-with-lower-case-letters/

Scroll to Top