Migrating to Postgres

Re:Migrating to Postgres by monkeyelite on Wednesday May 14, 2025 @08:51PM (#43990735)

There are probably fewer than 100 websites that couldn’t be a single Postgres instance on nice server hardware, with good caching.

[ Parent | on HN ]

Re:Migrating to Postgres by ScalaHanSolo on Wednesday May 14, 2025 @09:24PM (#43990919)

Yeah, this is our read with Postgres here at Motion. I believe that Motion will easily be able to 10x on modern hardware along with various optimizations along the way.

[ Parent | on HN ]

Re:Migrating to Postgres by kevml on Wednesday May 14, 2025 @09:32PM (#43990958)

Not everything on the internet is a “website” and then there are several website hosting platforms that aggregate the individual concerns.

[ Parent | on HN ]

Re:Migrating to Postgres by monkeyelite on Wednesday May 14, 2025 @09:34PM (#43990974)

All true points. I guess I just want to hear more about why they think sharding is important to them.

[ Parent | on HN ]

Re:Migrating to Postgres by maz1b on Thursday May 15, 2025 @03:15AM (#43992601)

What makes you say that? AFAIK, the largest single dedicated servers you can buy on the market go up to around hundreds of cores and terabytes of ram, and NVME up to a PB~ish if you stack NVME/SSD/HDD as well. this is when i last checked.

[ Parent | on HN ]

Re:Migrating to Postgres by monkeyelite on Thursday May 15, 2025 @10:58AM (#43995752)

Yes. What do you have in mind?

[ Parent | on HN ]

Re:Migrating to Postgres by maz1b on Sunday May 18, 2025 @01:59AM (#44019289)

You mentioned how there's ~100 organizations that need more than one instance of postgres, wanted to know how you arrived at that opinion.

[ Parent | on HN ]