[mattj]

Yup! My experience with redshift has actually made me curious to try out Postgres (I've always used MySQL before this). The stricter SQL dialect was a little odd at first, but I think I've become more comfortable with it over a few months.

[noir_lord]

Do it, I switched to Posgress for pretty much everything last year and I absolutely adore it, it just works, no stupid edge cases, excellent documentation, nice tooling (pgadmin3 is better than commercial products I've seen costing hundreds if not thousands).

I'm barely scratching the surface of what it is capable of yet as well (mostly because I'm in ORM land most of the time).

[endersshadow]

Postgres is an amazing database, and has some great features. Sadly, you don't get the full power of it in Redshift, but man, are some of the datatypes and functions just so useful, especially in a warehousing environment!