Andrew Kane
Andrew Kane
Hi @wahajali, for pgvector specifically, the data should already be in shared buffers, so prewarming shouldn't make a difference.
Yes, and when the index is created. You can run the benchmarks with and without `pg_prewarm` to compare.
Hey @fabienpiette, there's not currently an option for it, but happy to consider it if someone finds a simple way to implement it. Do you have a specific use case...
One way I've seen work well is having a single replica in `database.yml` and setting a different `REPLICA_DATABASE_URL` in the environment for different sets of servers.
[Supabase](https://supabase.com/docs/guides/database/extensions/hypopg)
[Amazon RDS](https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-extensions.html)
[Neon](https://neon.tech/docs/extensions/pg-extensions)
Hey @jangorecki, thanks for the ideas. I added support for RPostgreSQL. I agree with keeping the package lightweight and minimizing dependencies, but don't want to reinvent/maintain a URL parser. As...
Quick follow-up: Made urltools optional since it's only needed if you use the url functionality. Didn't realize that it had two dependencies itself.
Hey @artemklevtsov, thanks for the suggestion. Since it only takes 1 line to convert a CSV/TSV into a data frame, I'm not sure a separate function is needed.