AWS Announces Amazon Aurora Supports PostgreSQL 12

I’ve looked pretty hard at moving my fairly large Postgres RDS to Aurora and the pricing is just very scary. I have a single 100GB instance running on fairly minimal hardware and serving a Django site with 6k monthly visitors. My usage is pretty concentrated during 9-6pm EST as I mainly serve US law firms and investment funds. Any idea if that will end up costing me a fortune to go Aurora? I’m worried about all of those requests in a short amount of time leading to it spinning up a lot of instances.

Re: AWS Announces Amazon Aurora Supports PostgreSQL 12

#5

Post by kyriakos » Mon, Feb 08, 2021, 4:55 AM UTC

iav wrote: post #4

I’ve looked pretty hard at moving my fairly large Postgres RDS to Aurora and the pricing is just very scary. I have a single 100GB instance running on fairly minimal hardware and serving a Django site with 6k monthly visitors. My usage is pretty concentrated during 9-6pm EST as I mainly serve US law firms and investment funds. Any idea if that will end up costing me a fortune to go Aurora? I’m worried about all of th…

AWS is really expensive as you scale unfortunately.

Re: AWS Announces Amazon Aurora Supports PostgreSQL 12

#6

Post by philliphaydon » Mon, Feb 08, 2021, 5:29 AM UTC

kyriakos wrote: post #5

iav wrote: post #4

I’ve looked pretty hard at moving my fairly large Postgres RDS to Aurora and the pricing is just very scary. I have a single 100GB instance running on fairly minimal hardware and serving a Django site with 6k monthly visitors. My usage is pretty concentrated during 9-6pm EST as I mainly serve US law firms and investment funds. Any idea if that will end up costing me a fortune to go Aurora? I’m worried about all of th…

AWS is really expensive as you scale unfortunately.

Not really. It very much depends.

Re: AWS Announces Amazon Aurora Supports PostgreSQL 12

#7

Post by x86_64Ubuntu » Mon, Feb 08, 2021, 5:50 AM UTC

iav wrote: post #4

I’ve looked pretty hard at moving my fairly large Postgres RDS to Aurora and the pricing is just very scary. I have a single 100GB instance running on fairly minimal hardware and serving a Django site with 6k monthly visitors. My usage is pretty concentrated during 9-6pm EST as I mainly serve US law firms and investment funds. Any idea if that will end up costing me a fortune to go Aurora? I’m worried about all of th…

I don't think AWS RDS scales like that with "a lot of instances". The only time you would have so many instances is from how many read replicas you setup, and if you have a standby instance. RDS isn't like an EC2 ASG. I might be wrong though ='(

Source: An AWS Certs Scrub

Re: AWS Announces Amazon Aurora Supports PostgreSQL 12

#8

Post by alphabettsy » Mon, Feb 08, 2021, 7:02 AM UTC

iav wrote: post #4

I’ve looked pretty hard at moving my fairly large Postgres RDS to Aurora and the pricing is just very scary. I have a single 100GB instance running on fairly minimal hardware and serving a Django site with 6k monthly visitors. My usage is pretty concentrated during 9-6pm EST as I mainly serve US law firms and investment funds. Any idea if that will end up costing me a fortune to go Aurora? I’m worried about all of th…

What’s the reason for using Aurora?

Re: AWS Announces Amazon Aurora Supports PostgreSQL 12

#9

Post by feydaykyn » Mon, Feb 08, 2021, 7:04 AM UTC

iav wrote: post #4

I’ve looked pretty hard at moving my fairly large Postgres RDS to Aurora and the pricing is just very scary. I have a single 100GB instance running on fairly minimal hardware and serving a Django site with 6k monthly visitors. My usage is pretty concentrated during 9-6pm EST as I mainly serve US law firms and investment funds. Any idea if that will end up costing me a fortune to go Aurora? I’m worried about all of th…

At your current scale, just adding a slave for redundancy and hot take over should be enough?

There's also the aurora serverless way which may be interesting since your workload is only a few hours a day. Scale up automatically during the peak and wind down the rest of the time.

Re: AWS Announces Amazon Aurora Supports PostgreSQL 12

#10

Post by pbalau » Mon, Feb 08, 2021, 7:31 AM UTC

iav wrote: post #4

I’ve looked pretty hard at moving my fairly large Postgres RDS to Aurora and the pricing is just very scary. I have a single 100GB instance running on fairly minimal hardware and serving a Django site with 6k monthly visitors. My usage is pretty concentrated during 9-6pm EST as I mainly serve US law firms and investment funds. Any idea if that will end up costing me a fortune to go Aurora? I’m worried about all of th…

> Any idea if that will end up costing me a fortune to go Aurora?

Define a fortune.