Aiven for PostgreSQL

Vorteile

I like how easy it is to create and manage Postgres instance using Aiven + it's not that expensive in comparison to other providers.

Nachteile

I would like to have more insights in query performance.

Vorteile

The general ease of operation for:
- Spinning up new databases
- Scaling up
- Scaling down
- Migrating to a different region
- Restoring backups
Is really great. It's amazing how many features you get out of the box.
The plans with redundancy are also cool because you get full access to the slave as a read-only replica, this means you can run heavy select queries without putting load on the main database.
There is a very significant "it just works" factor to it, which is not something I would imagine myself saying about a database provider so easily.

Nachteile

They are not the cheapest
Monitoring/alerting options were a bit lackluste, but this has improved recently.

Vorteile

The best thing are the no-downtime migrations and upgrades. The setup was quick and easy and since then no maintenance has been required. Customer service is great and pro-active. The dashboard works well.

Nachteile

As far as I can tell there's no way to set a separate billing email.

It would be nice to also see in the dashboard what's taking up most memory and disk space and to be able to set up alerts, such as if there are queries that take too long to execute.

Vorteile

I have only used the PostgreSQL service so far and I really like how easy it is to start, fork en upgrade the service.

A great feature, and a must for us, is that you can choose on which cloud provider and location the service should be deployed.

We have been hosting our own PostgreSQL server for years and had to manage upgrades, backup and scaling on our own. And it feels great to finally leave that behind us and start using PostgreSQL as a service.

The support is great to. I have been in contact with the support using the chat feature and have been helped every time.

Nachteile

The official API client was a bit hard to understand at first.

Vorteile

- latest version of PostgreSQL available nearly immediately
- great performance
- easy-to-understand UI with enough power to do everything I needed
- straightforward solution, not excessively complicated
- ability to deploy into cloud provider of my choice, no lock-in
- clear pricing
- excellent support

Nachteile

- not possible to leverage free credits from cloud providers

In Betracht gezogene Alternativen

Vorteile

Can't fault Aiven at all, great service, the exact services we require (postgres and elasticsearch) and always more than willing to help

Nachteile

While it is a managed service you do need to have at least a minimum of knowledge to setup and run the services on offer.

Vorteile

It's incredibly easy to spin up a postgreSQL instance and start being productive. Everything from creating a secure password to SSL-certificates are handled automatically. Point in time backups make you confident to use and test without gambling hours of work and for the serious tests and development environments - spin up a replica by forking the database with the press of a button!

Nachteile

It is a bit expensive if you need more disk space, which isn't unusual when dealing with data and databases.

Vorteile

Lo que más me gusta es la facilidad de uso, poder trabajar de forma segura y rápido

Nachteile

No tengo ningún contra. Recomiendo el programa

Vorteile

Aiven makes it trival to move databases between cloud providers. The stickiest thing about any hyperscaler (AWS/Google/Azure) is your data - it's a PAIN to move. Aiven makes changing your cloud provider a literal point and shoot operation, something that could take weeks of planning trying to from RDS to Cloud SQL or the like.

Nachteile

A little more customization in the pricing would be nice (and the ability to run within a VPC instead of having to peer VPCs), but honestly there's very little I don't like about Aiven.

Vorteile

graph of metrics
query statics
easy admin of users
the autimatic backups and restores
the upgrades of service plans is a very easy and autimatic
the agents of service desk are very efficent and friendly

Nachteile

can't watch logs of befores days
aiven dont have a panel to execute querys, i could execute querys without any administrator of postgresql from your platform
cant admin sessions, i could close to sessions without pgadmin

Vorteile

The confidence I have that the DB will be running, that if there is an update or upgrade I can (from the DB side) simply click a button to deploy it.

Nachteile

We are currently transitioning most of our app to k8s and the systems just don't seem to work super well with Digital Ocean's current solution. (We don't get VPC's and as such have issue with whitelisting correct IP's as they tend to change)

Vorteile

It works. It seems stable. We hope someones is handling all the version updates and patches for us, but we don't get a lot of visibility into that.

Nachteile

It's expensive and I'm not sure how much value Aiven is providing us. We consider just running Postgres on our own cloud almost every day.

Vorteile

The interface is easy to use and intuitive.

The remote replica option is saving the company time. In the past, it was hard to manage and configure the remote replicas using tools like Bucardo and PostgreSQL in RDS, which does not support binary replication (at least it didn't back then).

The replicas between the remote databases happen almost instantly.

Great support for extensions.

Nachteile

The chat support takes a long time to answer the questions but when they do, the answers are to the point and helpful.

In Betracht gezogene Alternativen

Warum Aiven for PostgreSQL gewählt wurde

Zuvor genutzte Software

Vorteile

It was just super simple to start using it. The possibility to deploy the service to the same locations where we host our capacity was crucial for us.

Also as a nice plus, aiven has made their own Terraform provider which we also use to manage our capacity.

Nachteile

Option to create "Service Accounts" would be really nice. Currently all the API tokens are tied to actual user accounts and that might cause problems at some point.

But other than that there's not much not to like :)

Vorteile

Ease of use, quick setup.
We easily migrated to cloud and don't have to manage PostgreSQL any more.

Nachteile

Not enough features and settings for PostgreSQL: for example: slow queries logs are missing and we have to monitor by third party tools.

Vorteile

The ease of deployment and the dashboard are super important to us and these guys seem to have put a lot of thought into building a toolset that works for devs.

Nachteile

I don't have anything useful to add here.

Vorteile

- the support provided during the sales cycle
- the exploration of possible options
- the platform is clear and user friendly
- great product, it took us a few hours to migrate from our database on premise to that on Aiven.

Nachteile

- the fact that we can only have Timescale Open Source features run on Aiven, and not the advanced features.

In Betracht gezogene Alternativen

Gründe für den Wechsel zu Aiven for PostgreSQL

Vorteile

It's clean, simple-to-use, and best of all, is serviced by very knowledgeable IT staff who can answer the finer details of our technical questions and make nuanced recommendations. The pricing plan is also friendlier than those offered by the bigger platforms.

Nachteile

It would be great if we can be on the trial plan too, and getting on it was a bit of a hassle, but otherwise not much complaints.

Vorteile

Availability and live migration feature is awesome

Nachteile

Last time (couple weeks) it still cannot zoom to specific range of time in metric dashboard or i am wrong remember

Vorteile

Ease of use, setup and configuration is done in no time at all.

Nachteile

Dark mode for the admin interface... "Jokes" aside, havent yet found something I am missing.

Vorteile

Performance is much higher than Amazon RDS

Nachteile

Failover can take quite a long time.

In Betracht gezogene Alternativen

Warum Aiven for PostgreSQL gewählt wurde

Zuvor genutzte Software

Vorteile

I like that is possible to deploy PostgreSQL within seconds. I also really like that is possible to upgrade to a minor or major version of PostgreSQL without a noticeable downtime. I like the offering of HA services. I like the great customer support.

Nachteile

That it is not possible to have customizable PostgreSQL logs. On our dedicated servers we customize this logs to show us querys that last longer than 5 seconds, currently this is not possible with Aiven.

Vorteile

Easy to use and manage for other users and device declaration

Nachteile

Nothing to report now, the management of authorized ip is not the most user-friendly, but good enough.

Vorteile

It's efficient: no downtime during migration scale up/down
And easy to use!

Nachteile

Maybe an "in customer cloud" deployment for small business could be appreciable

In Betracht gezogene Alternativen

Warum Aiven for PostgreSQL gewählt wurde

Gründe für den Wechsel zu Aiven for PostgreSQL

Vorteile

- Good Terraform support
- TimescaleDB support (plus other addons)
- Very responsive sales and engineering department
- Supports all major cloud providers including Azure

Nachteile

- Pricing is more expensive than Azures own Postgres (but that doesn't TimescaleDB)

Vorteile

Simplicity and ease of use.
Integrates well as a middle component of the data pipeline: source to Aiven to multiple destinations.
No issues with performance.

Nachteile

nothing

Vorteile

simple to use, performant and reliable.

Nachteile

Had to create a temporary grafana installation to grab the prometheus dashboard and took some considerable time to adapt it to our own self-hosted installation.

Vorteile

Easy and fast to start a new service.
Easy service overview.
Nice pricerange from hobby to business

Nachteile

We had a service issue some time ago where we had no database for 4 hours. We needed to upgrade to business to have better fallback

Vorteile

Setup is very intuitive, and it seems to work great. Support was prompt and knowledgeable (which is hugely important). PG features seem solid and the flexibility to choose the cloud hosting, size etc is great.

Nachteile

easy Redis backup/import is still missing unfortunately. We'd love to use Aiven for redis too, but with those limitations we can't yet.

I'm still a bit hesitant about how likely Aiven is to stay in business as a company. It's not so well known and hard to know who's behind it and that it's doing well financially to keep going for many years. (btw, I think you guys should be more active on HackerNews and other geek channels where you should market yourselves.)

Vorteile

Aiven provides premium security for all accounts, not as an add-on feature.

Nachteile

The terraform plugin is not up to full feature parity, but covers most of our use cases.

Vorteile

Ease of setup and peering, account manager was helpful and responsive throughout the evaluation process, ease of upgrading instance, SLA of 100% is very appealing, just takes some of the worries away that we have :)

Nachteile

createing a read-replica and not being able to select the specific custom vpc from aws.

Vorteile

Easy to deploy and setup replication on any cloud provider we like

Nachteile

We want to move to our production environment but we need a SOC2. Currently, aiven does not have that. WHEN WILL YOU GET IT?!

Vorteile

The console was easy to use and intuitive. We were evaluating GCP CloudSQL vs Aiven and really what it came down to is that Aiven has better up time. CloudSQL has maintenance periods of 5-10 minutes that render the service unavailable, which is unacceptable for our uses. We also liked that Aiven could host on any major cloud platform (on GCP in our case).

Nachteile

At first it wasn't clear to me at first that I needed to connect to the DB and create users and manage the permissions manually through the CLI. Might be nice to have an initial user creation or way to manage the db users in the console.

In Betracht gezogene Alternativen

Vorteile

-Ease of deployment and a centralized place to manage multiple databases and services.
-Ability to choose region to deploy in

Nachteile

- I still had credits left but my trial ended at the 30 day mark. This wasn't a huge deal and I saw the credits role over but typically with credit based trials (AWS GCP Azure) you can go until your credits are used up.

Vorteile

The ability to link to our Google cloud cluster using VPC was very valuable. Features such as PITR and connection pooling makes Avien PostgreSQL in another league entirely when it comes to cloud services. Well done.

Nachteile

It would be useful to allow a whitelisted IP address into the service even when its configured with VPC

Vorteile

Its so easy to set up and get started with, and the blog article that tells you how to set up timescale db (that was the primary reason we needed aiven in the first place). I love it.

Nachteile

Nothing to do with the service, but the fact that timescaledb wont let us use the enterprise license in aiven is deeply disappointing. But love aiven, keep up the great work guys

Vorteile

Excellent "managed" db setup, overall. I liked how Aiven seemed to abstract the cloud-company-centric database offerings that each cloud co offers but made it appear "seamless" to me.

Nachteile

Could use a better explanation of pricing w.r.t. what the standard google/amzn/do db setup might cost.

Vorteile

Zero-downtime migrations and plan changes, database forks, nice metrics with iops.
Configuration seems to be hand-crafted to the installation, which is nice.

Nachteile

Plans could be more flexible in terms of space. Would be great to be able to choose disk space independently. Even for a small database which is used to store archive data, it gets very expensive.

Vorteile

Easy cloud based management of all database operational aspects.

Nachteile

Low limits on maximum connections for SaaS use-cases where a large number of connections are required.
Do not have root/postgres admin access to install custom extensions.

Vorteile

The feature set (cross-regional replication, live migration, logical decoding), and support. Support has been amazing.

Nachteile

No mainland China support. I understand that's difficult though.

Vorteile

Absolutely easy setup. Just a few clicks and everything is up and running. No overhead configuration or to database specific.

I needed a Database as a service, i got a database as a service. Nothing more to say.

Nachteile

I miss a little button to start a database backup by myself. Maybe it is there somewhere, but i am too blind...

Vorteile

Cloud Version.Local SSDs, faster than our previous postgresSQl.

Nachteile

Couldn't find anything so far but will def point out if I find in near future.

Vorteile

The product is Fast and reliable and the interface is user friendly

Nachteile

Storage sizing is not independent from machine sizing

Vorteile

I enjoyed using the Aiven console a lot. It is very straightforward to use, well-organized and documented.

Nachteile

Not much to complain about. Probably Services overview page could provide connection details straight away, so the user doesn't have to click on the service name to find the host and port.

Vorteile

Easy deployment
Multi cloud replication
Performance

Nachteile

A little costly
Everything else is great :)

Vorteile

Aiven services on PostgresSQL is the easier I ever met. the admin UI is user friendly, and the whole thing is secured.

Nachteile

The time of start and stop is quiet long, but it's really nothing so far.

Vorteile

No brainer provider that supports multiple cloud providers. Very easy to use and configure and customer support very helpful when needed.

Nachteile

I haven't encountered any downside so far.

Vorteile

Facilité de gestion/création de base/role.
Accès aux logs sans complexité.
Votre extension aiven_extras est intéressante.

Nachteile

1° Les "Advanced configuration" sont mal placées dans l'Overview : un onglet spécifique serait nécessaire ?
2° Il manque un équivalent pgdumpall.

Vorteile

Easy to get started with, support is reactive, overall it is a great experience for newcomers.

Nachteile

It is not much but some details about the settings of postgresql are not easy to access.

Vorteile

I really like UI/UX. It is clean enough!

Nachteile

Not enough options. Like, need filter metrics by specific dates (not only by d/w/m/y). Or sort current queries by time.