News for hackers. Stuff that matters.
Re:PostgreSQL Full-Text Search: Fast When Done Right (Debunk... by retakeming on Wednesday April 09, 2025 @12:10AM (#43628811)
The segments themselves being immutable doesn't mean that Tantivy is incompatible with Postgres - it just means that Tantivy needs to be made compatible with Postgres' concurrency control mechanisms (MVCC) and storage format (block storage). This blog post explains the latter: https://www.paradedb.com/blog/block_storage_part_one
Re:PostgreSQL Full-Text Search: Fast When Done Right (Debunk... by sunzhousz on Wednesday April 09, 2025 @11:53AM (#43633501)
the fundamental mismatch i saw is "creating a new segment for each individual dml", it is possible to alleviate but i don't think there's a good general solution.