5 ms·

Amazon RDS for PostgreSQL

60 points by jeffbarr 13y ago

codysoyland 13y ago
It's interesting to see this launch just days after Heroku Postgres 2.0 (https://postgres.heroku.com/blog/past/2013/11/11/heroku_postgres_20 https://postgres.heroku.com/blog/past/2013/11/11/heroku_post...). I would like to see a thorough comparison.
simonebrunozzi 13y ago
Great feature!
deleted 13y ago
[deleted]
- prayag 13y ago
  Crazy fast? The first request of Postgres on RDS was made over 4 years ago. https://forums.aws.amazon.com/thread.jspa?threadID=37834&start=0&tstart=-3 https://forums.aws.amazon.com/thread.jspa?threadID=37834&sta...
  - euphemize 13y ago
    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.
defen 13y ago
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.
- jeffbarr 13y ago
  You can use the Amazon RDS Parameter Groups to exercise control over dozens of PostgreSQL settings.
amock 13y ago
Why is PostgreSQL more expensive than MySQL?
thatthatis 13y ago
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.
integraton 13y ago
Really happy to see this. The only thing that seems to be missing is pl/v8 support. In case anyone from amazon is reading this, I've noticed that the functions floating around on github for the new json data type are using pl/v8, and I suspect this will only become more common.
- wiredfool 13y ago
  No plpython either, but since that's an untrusted language, I can totally see why they're not supporting it.
makmanalp 13y ago
I'll just leave this here: http://wiki.postgresql.org/wiki/Things_to_find_out_about_when_moving_from_MySQL_to_PostgreSQL http://wiki.postgresql.org/wiki/Things_to_find_out_about_whe... Plus, I've heard that mysql will ignore maxlength for chars, causing issues when moving those to postgres.
- csutter 13y ago
  That is extremely out of date and no longer relevant.

60 points by jeffbarr 13y ago

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

simonebrunozzi 13y ago

Great feature!

deleted 13y ago

[deleted]

prayag 13y ago
Crazy fast? The first request of Postgres on RDS was made over 4 years ago. https://forums.aws.amazon.com/thread.jspa?threadID=37834&start=0&tstart=-3 https://forums.aws.amazon.com/thread.jspa?threadID=37834&sta...
- euphemize 13y ago
  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.

defen 13y ago

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.

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

amock 13y ago

Why is PostgreSQL more expensive than MySQL?

thatthatis 13y ago

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.

integraton 13y ago

Really happy to see this. The only thing that seems to be missing is pl/v8 support. In case anyone from amazon is reading this, I've noticed that the functions floating around on github for the new json data type are using pl/v8, and I suspect this will only become more common.

wiredfool 13y ago
No plpython either, but since that's an untrusted language, I can totally see why they're not supporting it.

makmanalp 13y ago

I'll just leave this here: http://wiki.postgresql.org/wiki/Things_to_find_out_about_when_moving_from_MySQL_to_PostgreSQL http://wiki.postgresql.org/wiki/Things_to_find_out_about_whe... Plus, I've heard that mysql will ignore maxlength for chars, causing issues when moving those to postgres.

csutter 13y ago
That is extremely out of date and no longer relevant.