Lev Kokotov

Results 134 comments of Lev Kokotov

I agree, I was thinking of implementing the same thing. Another approach could be to patch Patroni to update PgCat's config when something changes in the cluster. Generally I think...

At the moment, that's true, but we can make it dynamic. Patroni does more things to the actual DBs, like reconfiguration after failover, so pgcat can't replace Patroni yet, and...

Hi, thank you for the PR. A few thoughts to make this work better: 1. Wait in the client instead of the pool to avoid grabbing a connection that may...

Hi there. Your assessment is correct, we just need to implement the `PARTITION BY HASH (uuid)` inside PgCat, which should very doable because our sharding logic is just a Rust...

Will test it out as soon as I can release the next version. Probably early next week, we're overdue for a release!

Hi, thanks for submitting the issue. One issue I'm seeing with this implementation is: > just try to open a connection to postgres with what you received and if that...

Try `pool_mode = "transaction"`. In session mode, the client is bound to the first server it talks to for the duration of the client connection.

That's not something we support at the moment. A PR would be welcome.

Sure. Implementing those metrics shouldn't be too difficult either, you can refer to the admin database for implementation. PRs for either paths are welcome.