Blog | postgresql

Get the latest updates and articles on postgresql

Back to main blog

All posts

16 September 2021

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.

Eero
31 August 2021|By

Solving the knapsack problem in PostgreSQL

04 August 2021|By

Get started with Apache Superset and PostgreSQL

23 June 2021

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.

Francesco
22 June 2021

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.

John
& Francesco
& Auri
11 June 2021

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.

Auri
03 June 2021

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!

Jonatas
24 May 2021

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.

John
& Auri
20 May 2021

Analysing Netflix shows with pgAdmin and PostgreSQL

Learn how to use pgAdmin with PostgreSQL by... watching movies? Find out more!

Francesco
25 March 2021

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.

Francesco
17 March 2021

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.

James
& Chris
26 February 2021

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.

Lorna
17 February 2021

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.

Trevor
17 February 2021

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!

Lorna
16 February 2021

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.

Auri
25 November 2020

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.

Auri
14 October 2020

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.

Auri
07 October 2020

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.

Helena
17 August 2020

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.

Michael
15 April 2020

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.

John
02 December 2019

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.

John
15 November 2019

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!

John
05 November 2018

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.

Kyle
01 November 2018

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.

Kyle
17 August 2018

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.

Hannu
27 June 2018

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.

Rauli
20 April 2018

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.

Oskari
13 April 2018

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.

Prem
03 April 2018

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.

Prem
01 March 2018

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.

Kyle
21 December 2017

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.

Oskari
09 November 2017

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.

Hannu
11 October 2017

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.

Hannu
31 May 2017

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.

Heikki
31 January 2017

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.

Oskari
28 December 2016

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.

Hannu
21 December 2016

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.

Hannu
20 December 2016

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.

Oskari
30 November 2016

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.

Oskari
01 October 2016

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.

Oskari
22 July 2016

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.

Oskari
16 June 2016

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.

Oskari
12 May 2016

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.

Oskari
28 April 2016

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.

Oskari
10 February 2016

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.

Mika
28 January 2016

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.

Mika
19 January 2016

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.

Hannu
12 January 2016

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.

Hannu

Let‘s connect

Aiven for Apache Kafka, Aiven for Apache Kafka Connect, Aiven for Apache Kafka MirrorMaker 2, Aiven for M3, Aiven for M3 Aggregator, Aiven for Apache Cassandra, Aiven for OpenSearch, Aiven for PostgreSQL, Aiven for MySQL, Aiven for Redis, Aiven for InfluxDB, Aiven for Grafana are trademarks and property of their respective owners. All product and service names used in this website are for identification purposes only and do not imply endorsement.