Hacker News new | ask | show | jobs
by redskyluan 445 days ago
What’s the largest deployment you’ve maintained in production?

If you’ve had the chance to manage one—especially while handling concurrent insert and search operations—you’ve probably felt the pain firsthand and understand just how critical scalability really is.

Insert into PGvector is super slow when data accumulate and the index build will take forever

1 comments

Depends on the hardware, sharding layout, bulk/individual insert and table bloat. Looks like you are missing pg_repack..