2 links tagged with all of: indexing + postgresql + optimization
Click any tag below to further narrow down your results
Links
This article explores creative database optimization techniques in PostgreSQL, focusing on scenarios that bypass full table scans and reduce index size. It emphasizes using check constraints and function-based indexing to improve query performance without unnecessary overhead.
This article details how VectorChord reduced the time to index 100 million vectors in PostgreSQL from 40 hours to just 20 minutes while cutting memory usage by seven times. It outlines specific optimizations in the clustering, insertion, and compaction phases that made this significant improvement possible.