PostgreSQL®

11 August 2022

Aiven Security Agent for PostgreSQL®

PostgreSQL extensions provide great functionality for users, but they are difficult to provide securely. Aiven has an open source solution to this problem!

James
17 June 2022

Announcing Dynamic Disk Sizing

09 June 2022

What is PostgreSQL®?

All things open source, plus our product updates and news in a monthly newsletter.

Subscribe to the Aiven newsletter

Yikes! We've been blocked!

This form was disabled by a content blocking extension.

We get it – the internet's a busy place these days.

Don't worry - you can access the form here.

  • Subscribe to RSS
17 May 2022

Setting up Django to use Aiven for PostgreSQL®

Django is a fully-featured high-level Python web framework. Read on to see how to get it to store its data in an Aiven for PostgreSQL® database.

Tibs
01 April 2022

Use cases for PostgreSQL®

PostgreSQL® is great for a huge variety of use cases involving data. Find out how Aiven's customers are using it as part of their data architecture.

01 April 2022

(Postgre)SQL concepts and terms

A glossary of terms related to PostgreSQL® and SQL in general.

31 March 2022

Secure your database access with HashiCorp Vault

Static credentials are a potential security risk. Learn how to setup dynamic credentials for your PostgreSQL® database with Hashicorp Vault.

Dewan
03 February 2022

Database migration with Apache Kafka® and Apache Kafka® Connect

Find out how to use Apache Kafka® to migrate across database technologies while keeping the target continually in sync with the source.

Francesco
20 January 2022

Quickly developing REST APIs with PostgREST

Setting up an HTTP interface to a database can be a lot of work. Find out how PostgREST makes it quick and simple to provide RESTful access to PostgreSQL®.

Jonatas
13 January 2022

Future PostgreSQL: Improvement to the Replication Protocol

Check out the latest improvement to PostgreSQL replication to which our OSPO team contributed to help solve reliability problems.

Ronan
14 December 2021

Explore the new SEARCH and CYCLE features in PostgreSQL® 14

Using recursive queries? Check out the new SEARCH and CYCLE features available in PostgreSQL 14 in this update to an earlier blog post.

Francesco
16 November 2021

Announcing Aiven for PostgreSQL® 14.0

We have upgraded to the latest PostgreSQL version. And it's great! Read on to find out what changes for you and what you need to do.

01 November 2021

Add Aiven database magic to your Laravel project

Using Laravel? Read about our new way to easily reconfigure your Aiven database connection: connect to any Aiven database and power off any unused ones.

Lorna
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. Find out how Aiven services perform across clouds.

Eero
31 August 2021

Solving the knapsack problem in PostgreSQL®

The knapsack problem: how to fit all the items you're most likely to need on holiday? Find out how to use the world's best OS database to help you pack.

Francesco
04 August 2021

Get started with Apache Superset and PostgreSQL®

Find out how to use Apache Superset to create data visualizations from a PostgreSQL table in an Aiven environment - and use it to drive your business decisions.

Francesco
23 June 2021

The pursuit of happiness with Python and PostgreSQL®

The world and the data in it are seldom perfect. Read 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. Find out here how to choose between them.

Auri
03 June 2021

Aiven databases and Terraform for fun and profit

Terraforming is hard and long-term, but using Terraform is the exact opposite. Read to find out how to manage your Aiven databases with this cool tool!

Jonatas
20 May 2021

Analyzing Netflix shows with pgAdmin and PostgreSQL

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

Francesco
25 March 2021

Using Kafka Connect JDBC Source: a PostgreSQL® example

Find out how to use Apache Kafka® Connect to to update an old app-to-db design to use up-to-date tech tools without disrupting the original solution.

Francesco
17 March 2021

Data and disaster recovery

We don’t like to think about disasters, but sometimes they just happen. 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, a PostgreSQL cookie with a splash of refreshing Go milk. Bon appetit!

Lorna
17 February 2021

Discover exoplanets with PostgreSQL® sample data

In this post, Lorna Mitchell populates an empty PostgreSQL database for testing with cool data about exoplanets. Read to learn how!

Lorna
17 February 2021

How to stand up multiregion PostgreSQL® with Pulumi

Improve PostgreSQL performance by setting up a multiregion service: isolate read-intensive workloads to replicas. Trevor explains how, using Aiven and Pulumi.

Trevor
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. Find out what to do if your services start to 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]

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
03 February 2020

Adeo takes development speed to new level with Aiven [Case Study]

Find out how and why the third largest global player in the home improvement market use Aiven.

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

Larger Aiven for PostgreSQL and Aiven for Apache Kafka® plans in Azure

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®

New amazing features added to Apache Kafka® & PostgreSQL®

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 now available

Our first offer, Aiven for PostgreSQL is now out. First, we’d like to thank all beta users. Now, we’d like to invite you to find out how to get it.

Hannu