3 ms·
> I need the control you won't have with a cloud offering (you can't install extensions) Depends on who you go with. Google's managed postgres thing lets you i
by remus 5y ago
> I need the control you won't have with a cloud offering (you can't install extensions)
Depends on who you go with. Google's managed postgres thing lets you install supported extensions.
https://cloud.google.com/sql/docs/postgres/extensions https://cloud.google.com/sql/docs/postgres/extensions
- mushufasa 5y ago> supported extensions in my experience, vendors support few extensions (for good reason), but lots of time you need a specific use-case in that long tail of unsupported extensions. for example, timescaledb isn't supported anywhere, so the options are managing it yourself or using their own hosted Postgres version.
- Lunrtick 5y agoDigitalOcean does offer Timescaledb in the their managed postgres offering AFAIK, along with quite a few other extensions (PostGIS etc)
- tpetry 5y agoBut does it offer the new TimescaleDB 2.0 with all the new features? They changed their license and made all enterprise features free but only for their Community License (for self-hosting). Cloud providers are only allowed to use the fully open source Apache licensed extensions which is missing some parts.
- gsa 5y agoThe version of Timescaledb offered by DigitalOcean is Apache licensed, which is somewhat limited compared to the community licensed version.
- tpetry 5y agoThey don't let you "install" an extension, the `CREATE EXTENSION` command is just enabling an installed extension for a specific database. There are a ton more extensions than Google Cloud SQL or AWS RDS support. Both of them for example don't have the often used hypopg extensions which allows you to hypothetical create an index to check whether it's used for your queries and see how your execution plan changes. Building indexes for large databases can take a lot of time.