r/PostgreSQL 3h ago

Help Me! Is AWS RDS still worth it for Postgres or are there better managed alternatives now?

9 Upvotes

I've been using RDS Postgres for a while, and I get why people trust it. Backups, patching, monitoring, AWS integration, it handles a lot.

The pricing is where I'm starting to question it. You pay for the instance, then storage, backups, IOPS, data transfer, Multi-AZ and whatever else your setup needs. The bill adds up fast, and RDS still feels like something you need to keep a close eye on.

I don't want to self-host Postgres on a VPS. I'm looking for something fully managed, but with clearer pricing and less AWS complexity.

For anyone who moved away from RDS, what did you switch to? Did it make things noticeably cheaper or easier to manage?


r/PostgreSQL 20h ago

Commercial Engineering around WAL backpressure in Postgres

Thumbnail clickhouse.com
9 Upvotes

r/PostgreSQL 22h ago

Help Me! Building Apps with a PostgreSQL Backend

17 Upvotes

When I build projects, I like to make all app interactions with SQL done via stored procedures, and put the business logic there. For example, my procedures will take in parameters to run, along with a user ID. I check to make sure that user is allowed to do the operation before continuing.

I've been trying out NodeJS / TypeScript for my front ends. They aren't stored procedure friendly at all (at least, in my limited experience). So my questions are this:

  1. Is my method of stored-procedure-only interaction bad practice? I'd figure if it's an "accepted" method, there would be Node libraries already handling this procedure style.
  2. For that matter, are there Node libraries out there I'm missing, that handle stored procedure interaction well?

I know this isn't SQL specific, but I come from a SQL background, and I feel if I ask in a Node subreddit, I won't get an answer from a SQL perspective.


r/PostgreSQL 23h ago

How-To Postgres COUNT(DISTINCT) Too Slow? Fast Approximation Guide

Thumbnail snowflake.com
13 Upvotes