Viewing profile — x4m

Was a flight to space an iteration?

As Odyssey maintainer, I have to admit that it is exceptionally difficult to achieve stability (e.i. quality) of PgBouncer. It has two limitations: it is single threaded and it is …

With Odyssey we have customers with 50k+ connections operating normally. Also consider SQPR - it's a connection pooler with sharding capabilities. It handles data migration between…

Just use https://github.com/yandex/odyssey :) It's a scalable PgBouncer.

I'd love to! But MySQL is developed inside Oracle, and OCA somewhat scares me. Perhaps, I'll give a try to MariaDB or other forks.

And there's also https://postgrespro.com/docs/enterprise/current/multimaster With a history behind it.

I think this should run just fine, why not? As long as you have proper Postgres operator, such proxy will run normally on top of that.

+1 there's already well maintained extension https://github.com/fboulnois/pg_uuidv7 It's slightly different from recommendations by draft RFC version (there's no counter), but full…

I've created few Docker-based educational tasks to try yourself in exploiting historical vulnerabilities. I'm not a realy docker-pro, many parts can be implemented in a wrong way. …

FWIW Steam Deck runs 8k transactions per second if you build Postgres there. A nice place to work on open source development, actually. https://twitter.com/x4mmmmmm/status/16209845…

> Reduce the memory usage of prepared queries FWIW Odyssey supports prepared statements in transaction pooling.

I concur that Odyssey docs are insufficient to build a big picture. But I'm trying to answer every question in the Internets about Odyssey :) Documenting is hard - everything seems…

I think the book is free because Egor and PostgresPro want to develop the community. If you want to pay back - you can just start contributing to Postgres. No need to wait :)

You are running on up to date version which seems to have no known critical bugs.

Just revert d9d0762 or use actual REL_14_STABLE.

Transaction pooling rules are equivalent in Odyssey and PgBouncer.