Aiven for PostgreSQL 13 performance on GCP, AWS and Azure [Benchmark]
Welcome to our latest benchmark figures for Aiven for PostgreSQL on AWS, GCP and MS Azure.
Solving the knapsack problem in PostgreSQL
Get started with Apache Superset and PostgreSQL
The pursuit of happiness with Python and PostgreSQL
The world is seldom perfect, and the same goes for real-life data. Read on to find out how to clean up the data in your PostgreSQL database so that it's usable for analysis.
Introducing Aiven for PostgreSQL change data capture
(Updated) How does PostgreSQL capture changes in data? Read this post for a look at the methods available.
PostgreSQL vs MySQL - the Aiven championships
Aiven offers both PostgreSQL and MySQL as managed services. While similar, they meet different needs. Read our new blog article to find out how to choose between them.
Aiven databases and Terraform for fun and profit
Terraforming is hard and long-term, but managing your databases with Terraform is the exact opposite. Read to find out how to manage your Aiven databases with this cool tool!
An introduction to PostgreSQL
(Updated) Join us for a browse at the ins and outs of PostgreSQL, and find out how to get it as a managed service from Aiven.
Analysing Netflix shows with pgAdmin and PostgreSQL
Learn how to use pgAdmin with PostgreSQL by... watching movies? Find out more!
Using Kafka Connect JDBC Source: a PostgreSQL example
How to update an old app-to-database design to include Kafka? Find out how to use Kafka Connect to integrate to an existing system and use up-to-date tech tools without disrupting the original solution.
Data and disaster recovery
We humans don’t like to think about disasters, but that doesn’t stop them from happening. Read to find out how you should prepare your data for the worst, even while hoping for the best.
Aiven for PostgreSQL for your Go application
Applications and databases go together like milk and cookies; on the menu today is a PostgreSQL-flavored cookie with a splash of refreshing Go milk. I've picked two of my favorite Go libraries as samples; read on to find out how to use them to connect to and work with your Aiven for PostgreSQL service.
How to stand up multiregion PostgreSQL with Pulumi
To improve the performance of your PostgreSQL database, consider setting up a multiregion service that will allow you to isolate read-intensive workloads to replicas while keeping write workloads on the primary. To learn how, read this tutorial where Trevor Kennedy explains the process using Aiven and Pulumi.
Discover exoplanets with PostgreSQL sample data
PostgreSQL is and remains one of our most popular and growing storage platforms. In this post, Lorna Mitchell populates an empty PostgreSQL database with cool data about exoplanets. Read to learn how!
Aiven for PostgreSQL 13 is now available
PostgreSQL 13 makes life easier with improvements to indexing, sorting, and vacuuming. Read on to learn how it makes your datasets cleaner and queries faster.
How to avoid high-load disasters in managed database services
Black Friday is THE peak load time of the year, the great holiday of the retail world. The combination of a short timeline and good deals overloads servers all over the world and makes it the classic case for peak load fault tolerance. Find out now what you can do if your services show signs of overload.
Aiven enhances happiness in the Himalayas [Customer Story]
In our first ever customer story, MyBhutan’s co-founder Matthew DeSantis shares with us how Aiven is contributing to the Kingdom of Bhutan’s development.
Ometria delivers customer insights faster with Aiven [Case Study]
Find out why Ometria chooses Aiven for PostgreSQL over Amazon’s RDS to power their retail marketing platform.
Spare partners with Aiven to build city transportation systems
Find out why Spare, a global transportation systems provider, chose Aiven for PostgreSQL for their application database needs.
PostgreSQL 12 performance on GCP and AWS [Benchmark]
In our latest benchmark, we look at Aiven for PostgreSQL version 12 plan performance between Amazon Web Service and Google Cloud Platform in terms of transactions per second and cost.
DBAs shouldn't be afraid of managed services
DBAs have raised a lot of objections about moving from on-prem (or self-hosted) to using managed services. In this post, we address each in turn.
Aiven supports managed PostgreSQL 12
PostgreSQL 12 is now available on Aiven. Find out how it'll greatly improve space usage and partitioning, and how you can access it today!
PostgreSQL 11 now generally available on Aiven
PostgreSQL 11 is now available on the Aiven platform. Read our latest post to find out what changes have been made to PG 11.
PostgreSQL major version in-place upgrades supported on Aiven
Now, Aiven users can perform PostgreSQL in-place major version upgrades in 60 seconds or less. Learn more in the latest blog post.
Aiven PostgreSQL now supports logical replication
With the help of our open source extension, Aiven users can perform logical replication without superuser roles. Read this post to learn more.
Why you should use Aiven for PostgreSQL dashboards
Read this latest post to find out why you should use PostgreSQL dashboards with examples of scenarios that are ideal for their use.
Aiven talks in PostgresConf US 2018
We visited New York and New Jersey this week to meet partners and speak in PostgresConf US in Jersey City.
Aiven PostgreSQL & TimescaleDB: A time series powerhouse
Find out how to take Aiven for PostgreSQL and turn it into the most advanced open source time series database with TimescaleDB in our latest post.
Remote read replicas - the what, why, and how
PostgreSQL remote read replicas enable users to increase their data availability, as well as read and write performance. Read more to learn how Aiven does it.
Aiven for PostgreSQL gets latest update, new features, and plan sizes
From offering TimescaleDB to lowering our prices in AWS and DigitalOcean, our PostgreSQL has undergone a few changes. Learn more here.
PostgreSQL Performance in AWS, GCP, Azure, DO and UpCloud
Want to know how PostgreSQL performs in different clouds, as well as best practices for benchmarking? Then be sure to check out our latest test results.
Aiven for PostgreSQL plans are now larger and faster with local SSDs
Aiven is the first DBaaS to support local SSDs. With performance increases of up to 400% over network-based SSDs, it’s a big deal. Read on to get the details.
Aiven is the first to offer PostgreSQL 10
PostgreSQL 10 is out and we’re the first to support it, not too bad for a small start-up from Finland. Find out what you get with the latest release here.
Larger Aiven for PostgreSQL and Aiven for Apache Kafka plans in Azure
Microsoft Azure continues to grow and so does the demand of Aiven services there, which is why we’ve added larger PostgreSQL and Apache Kafka plans; learn more.
Lower PostgreSQL pricing in AWS
When we win, our users win. Because of savings we’ve realized in AWS infrastructure costs, we’ve been able to reduce PostgreSQL prices by 10 - 30%. Learn more.
Aiven for PostgreSQL read-only replicas
PostgreSQL read-only replicas increase read throughput and take some load off of your master node. We go into great detail in this latest post, check it out.
Aiven for PostgreSQL connection pooling
Find out how to keep server resource usage low in spite of insanely large numbers of connections to your PostgreSQL database with connection pooling.
New amazing features added to Apache Kafka & PostgreSQL
Our region count is now 51 and we’re celebrating by adding new features to Aiven for Apache Kafka and Aiven for PostgreSQL. Find out what features we added.
Aiven in Google Tokyo & other updates
Aiven is now active in Google Tokyo and we’re planning some feature additions to our Kafka and PostgreSQL services. Find out more.
PostgreSQL 9.6 now available in AWS, Azure, Google Cloud
PostgreSQL 9.6 is now available across Aiven, increasing its ability to handle large amounts of data. Get a quick summary from our latest post.
Backing up tablespaces and streaming WAL with PGHoard
Our open-source PGHoard’s latest version is now available. Find out what new features were added and how to get the most out of it.
Even bigger PostgreSQL plans now available
Our bread and butter is PostgreSQL, which is why we continue to add bigger and better plans to Aiven. Find out the latest plan options here.
Help test PostgreSQL 9.6 via Aiven
Want to be the first to test PostgreSQL 9.6 and its new features? Check out how you can test the beta on the Aiven platform here.
PostgreSQL cloud backups with PGHoard
Aiven-built PGHoard is a pretty neat cloud backup and restore solution. Find out what it does exactly and how to set it up in this latest blog post.
Bigger, faster, cheaper Aiven for PostgreSQL service plans!
Full daily backups, and real-time streaming of incremental backups are only a few of the improvements to Aiven for PostgreSQL. Find out what else we’ve done.
Aiven for PostgreSQL tutorial
Our in-depth tutorial covers multiple aspects of setting up and running Aiven for PostgreSQL through out platform. Find out just how easy it is here.
Aiven for PostgreSQL now available in UpCloud
UpCloud is our latest cloud vendor. Find out which regions are immediately available and what our future plans entail for Aiven for PostgreSQL here.
Aiven for PostgreSQL is now publicly available
Our first offer, Aiven for PostgreSQL is now publicly available. First, we’d like to thank all beta users. Now, we’d like to invite you to find out how to get it.