What's wrong with Postgres + pgvector in production? pgvector is supported by RDS. Keeping an RDS instance running in production isn't exactly rocket science.
It's no match for lucene (in practice ES or Solr) in terms of performance and features, as it's very different model of indexing and operating.
Keeping it running while 1000s of customers run search queries AND the app uses db AND users want faceting or other features is not an option.