4 ms·
Not meaning to be an ass, but this is really bad advice. Redshift is not supposed to be used like Postgres. Redshift is a data warehousing solution, with compl
by dguaraglia 10y ago
Not meaning to be an ass, but this is really bad advice.
Redshift is not supposed to be used like Postgres. Redshift is a data warehousing solution, with completely different tradeoffs, and accommodating completely different work loads than your average Postgres database. For example, you can't create indices on Redshift tables or relationships between them, the consistency story is completely different from Postgres and Redshift is optimized for bulk loads, not millions of discrete inserts/updates a second.
Amazon RDS does provide hosted Postgres, and that is what you want to use if you want managed Postgres. Or you can use Herokus's hosted Postgres (it does get expensive with size, though.)