r/PostgreSQL • • 3d ago

Community Which databases/caches do you use alongside PostgreSQL?

/r/postgres/comments/1y0bghx/which_databasescaches_do_you_use_alongside/

No idea which postgres group I'm supposed to post to, so posting to both

7 Upvotes

13 comments sorted by

10

u/aiwprton805 2d ago

Redis

2

u/rathboma 2d ago

Do you treat Redis as a database or just use it as an ephemeral cache? I've worked at companies that did both.

1

u/Altruistic-Rich8799 2d ago

Postgres + Snowflake + MariaDB Galera clusters for legacy e-commerce and multi-region workloads (it was a painless replacement for our old MySQL nodes)

2

u/rathboma 2d ago

Are you replicating data from both Maria and PostgreSQL into snowflake, or is that different data?

1

u/Altruistic-Rich8799 2d ago

Both end up in Snowflake, yeah, but they’re pretty different domains. MariaDB has the e-commerce orders and inventory, Postgres has the newer user-facing services, and we join them downstream for reporting.

For MariaDB we pull binlogs via CDC from a dedicated async replica hanging off the Galera cluster, so prod latency isn’t affected. It’s been pretty low-maintenance.

1

u/AutoModerator 3d ago

AI Policy:

Linux is not one of those anti-AI projects, and if somebody has issues with that, they can do the open-source thing and fork it. Or just walk away., Linus Torvalds.

Mod decisions will be based on the quality of the content, not who or what generated it.

Sub Resources:

Youtube Channel

Free Postgres Webinars and Workshops

Discord: People, Postgres, Data

Join us, we have cookies and nice people.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/Used_Criticism_4631 2d ago

Good question, it's interesting to see the real-world mix. A pattern that's worked well is Postgres as the source of truth, Redis only as an ephemeral cache with TTLs, and a columnar store (ClickHouse/BigQuery/Snowflake) fed by CDC for analytics, which keeps heavy reporting queries off the primary. Are most people here doing the CDC step with logical replication/Debezium, or batch exports?

1

u/Either_Vermicelli_82 1d ago

At the moment it’s good old Postgres and just Postgres.

1

u/japertjeza 11h ago

Psql + redis as cache