Amazon RDS for PostgreSQL

#1

Post by jeffbarr » Thu, Nov 14, 2013, 5:10 PM UTC

Amazon RDS for PostgreSQL
aws.typepad.com

Re: Amazon RDS for PostgreSQL

#2

Post by codysoyland » Thu, Nov 14, 2013, 5:16 PM UTC

It's interesting to see this launch just days after Heroku Postgres 2.0 (https://postgres.heroku.com/blog/past/2013/11/11/heroku_post...). I would like to see a thorough comparison.

Re: Amazon RDS for PostgreSQL

#3

Post by simonebrunozzi » Thu, Nov 14, 2013, 5:16 PM UTC

Great feature!

Re: Amazon RDS for PostgreSQL

#4

Post by [deleted] » Thu, Nov 14, 2013, 5:18 PM UTC

[deleted]

Re: Amazon RDS for PostgreSQL

#5

Post by defen » Thu, Nov 14, 2013, 5:23 PM UTC

As someone who's never used RDS - does this let you adjust the postgresql.conf settings? Specifically interested in turning off synchronous commit or adjusting shared_buffers. If that is possible this would be a godsend.

Re: Amazon RDS for PostgreSQL

#6

Post by prayag » Thu, Nov 14, 2013, 5:25 PM UTC

[deleted] wrote: post #4

[deleted]

Crazy fast? The first request of Postgres on RDS was made over 4 years ago. https://forums.aws.amazon.com/thread.jspa?threadID=37834&sta...

Re: Amazon RDS for PostgreSQL

#7

Post by amock » Thu, Nov 14, 2013, 5:27 PM UTC

Why is PostgreSQL more expensive than MySQL?

Re: Amazon RDS for PostgreSQL

#8

Post by jeffbarr » Thu, Nov 14, 2013, 5:28 PM UTC

defen wrote: post #5

As someone who's never used RDS - does this let you adjust the postgresql.conf settings? Specifically interested in turning off synchronous commit or adjusting shared_buffers. If that is possible this would be a godsend.

You can use the Amazon RDS Parameter Groups to exercise control over dozens of PostgreSQL settings.

Re: Amazon RDS for PostgreSQL

#9

Post by euphemize » Thu, Nov 14, 2013, 5:29 PM UTC

prayag wrote: post #6

[deleted] wrote: post #4

[deleted]

Crazy fast? The first request of Postgres on RDS was made over 4 years ago. https://forums.aws.amazon.com/thread.jspa?threadID=37834&sta...

True, they weren't very fast on this one. But they're usually good at quickly pushing out new services/features/apis and integrating new products from acquired companies.

Re: Amazon RDS for PostgreSQL

#10

Post by thatthatis » Thu, Nov 14, 2013, 5:32 PM UTC

I'm happy to see that this appears to be a full-featured (or near fully featured) service that includes postgis and hstore.

I'm looking forward to seeing the inevitable rds vs comparably priced heroku benchmarks.