I saw AlloyDB is being promoted on Google cloud. https://cloud.google.com/products/alloydb?hl=en
Price of it is cheaper than the PostgreSQL. Per this article
I am wondering if anybody tried using this instead of PostgreSQL since Google claims that it is 100% PostgreSQL-compatible.
إعجاب واحد (1)
Falco
(Falco)
16 أكتوبر 2025، 5:03م
2
I tested on Aurora when it launched the PostgreSQL compatibility and it worked pretty well back then, so I assume it will be the same here.
That said, Discourse scales pretty well on a single managed PostgreSQL vertically, so I’m interested in how much activity you see that trying something like this would make sense from a risk-reward perspective.
إعجابَين (2)
Yeah.. that’s true..
The only incentive for us was the price seems to be a bit lower.
Falco
(Falco)
16 أكتوبر 2025، 6:49م
4
Which instance type are you using for the GCP PostgreSQL instance?
Our current one is this:
vCPUs: 8
Memory: 64 GB
SSD storage: 596 GB
Enterprise Plus edition
Data Cache is enabled (375 GB)
إعجاب واحد (1)
That’s enormous.
How many active users do you serve?
On admin dashboard, daily participating user is about 2.5k.
I ran this query with count and got 28k.
This should give you every user that have either read whilst logged in or posted over the last year. The data explorer will also print out how many they are.
SELECT p.user_id
FROM posts p
LEFT JOIN topics t ON t.id = p.topic_id
WHERE p.created_at::date > CURRENT_TIMESTAMP - INTERVAL '365 days'
AND t.deleted_at IS NULL
AND t.visible = TRUE
AND t.closed = FALSE
AND t.archived = FALSE
AND t.archetype = 'regular'
AND p.deleted_at IS NULL
UNION
SELECT u.user_id
FROM user_visits u
WHERE u.posts…
إعجاب واحد (1)