x4m

21 ms·

1.
by x4m 2mo ago
Was a flight to space an iteration?
2.
by x4m 2mo ago
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 developed only re-actively. PgBouncer docs used to say that
3.
by x4m 2mo ago
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 shard on top of request routing. Odyssey will inherit
4.
by x4m 2mo ago
Just use https://github.com/yandex/odyssey :) It's a scalable PgBouncer.
5.
by x4m 7mo ago
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.
6.
Unmerged Patches and Useful Failures: My Journey to Postgres Major Contributor(medium.com)
9 points by x4m 7mo ago|2 comments
7.
by x4m 1y ago
And there's also https://postgrespro.com/docs/enterprise/current/multimaster With a history behind it.
8.
SPQR 2.6.0 with Multicolumn Sharding(github.com)
5 points by x4m 1y ago|2 comments
9.
by x4m 2y ago
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.
10.
WAL-G 3.0.0 – fast partial cluster recovery for Postgres(github.com)
12 points by x4m 3y ago|1 comments
11.
by x4m 3y ago
+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 fully within spec requireme
12.
How to make your first contribution to ClickHouse(youtube.com)
3 points by x4m 3y ago|0 comments
13.
Show HN: Postgres Security Educational Tasks(github.com)
1 points by x4m 3y ago|0 comments
14.
Compute\Storage Disaggregation for GreenplumDB(github.com)
18 points by x4m 3y ago|0 comments
15.
by x4m 4y ago
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/1620984546216017921
16.
Postgres Hacking 101: Buffer Page and Its API(youtube.com)
1 points by x4m 4y ago|0 comments
17.
Postgres Hacking 101: Benchmarking a Patch(youtube.com)
7 points by x4m 4y ago|0 comments
18.
by x4m 4y ago
> Reduce the memory usage of prepared queries FWIW Odyssey supports prepared statements in transaction pooling.
19.
by x4m 4y ago
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 obvious to me, but understand that may things are not
20.
by x4m 4y ago
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 :)
21.
by x4m 4y ago
You are running on up to date version which seems to have no known critical bugs.
22.
by x4m 4y ago
Just revert d9d0762 or use actual REL_14_STABLE.
23.
by x4m 5y ago
Transaction pooling rules are equivalent in Odyssey and PgBouncer.
24.
by x4m 5y ago
It seems like there's issue when you have a user for accessing authentication table you login with the same user. It fails when due to mixing same pool for auth and for work. I'll look into differentiating these pools more closely
25.
by x4m 5y ago
Odyssey could work fine on arm, but we've a small ASM function https://github.com/yandex/odyssey/blob/master/third_party/ma... . We need to reimplement it for ARM64 or at least fallback on some
26.
by x4m 5y ago
Odyssey stands before the databases and packs thousands of NodeJS connection into few tens of real server connections.
27.
by x4m 5y ago
I'm not actually aware of all detailed plans. My job is to advance PostgreSQL ecosystem. But I'll pass a question to someone with broader view.
28.
by x4m 5y ago
I think there's a lot of different HA solutions - Patroni, Stolon, Pacemaker to name few.
29.
by x4m 5y ago
I heard FAANG is now MANGA :)
30.
by x4m 5y ago
There's already working part of libpq protocol for this - target_session_attrs. But the problem with target_session_attrs is that it just takes too long to discover new primary after failolver. We want to fix this within Odyssey.

More ›