November 2020

Welcome to the 3rd issue of the Swarm64 PostgreSQL newsletter. Feel free to share this with friends and sign up to get relevant news for PostgreSQL performance innovations and best practices.

Swarm64 DA Product News

Announcing Swarm64 DA 5.0 – Free Developer edition – run it anywhere

We have released Swarm64 DA 5.0, which makes it even easier to accelerate Postgres query performance 5x – 60x to help you handle more data, more users, or more query complexity.

Announcing PG Nitrous – PostgreSQL cloud. 30x faster queries than RDS

Announcing PG Nitrous, a new PostgreSQL cloud for people who want fast query performance. Hosted on AWS and powered by Swarm64 DA. Try it for free for 30 days.

Swarm64 PostgreSQL News & Knowledge

A 2nd look at Postgres V13 improvements

Cybertec’s Kaarel Moppel takes a 2nd glance at the Postgres V13 release notes and shares his observations.

Compression and columnstore indexes

Learn the pros and cons of different compression settings for PostgreSQL columnstore indexes to help you tune performance better.

PostgreSQL clustering: VIP-Manager

How can you make a PostgreSQL cluster transparent? How does the application figure out where the primary database is? The VIP-manager (Virtual IP Manager) is a simple to use tool to handle service IPs in a PostgreSQL Patroni cluster.

PostgreSQL: Foreign keys and insertion order in SQL

PostgreSQL foreign key constraints enable referential data integrity. This blog post shows how to cope with the resulting restrictions on the data ingestion order.

Professionalism matters – Even when working remote

The opportunity for success is only limited by your willingness to put in the right amount of effort. 

Connect with PostgreSQL users on Discord

Join the Postgres Discord server to learn more about PostgreSQL, share feedback, ask questions, find events, and connect with PostgreSQL community members. 

Swarm64 Partner News

New version of PGWatch released

Cybertec released a new version of their PostgreSQL Monitoring tool PGWatch.

PG Timetable – Advanced job scheduling

pg_timetable is a PostgreSQL job scheduler developed by CYBERTEC. It offers cutting edge flexibility and a large variety of features.

PostgreSQL Events & Webinars

Introduction to PG Nitrous – PostgreSQL cloud – Dec 02, 2020, 10 am (PT)

PG Nitrous is a new PostgreSQL cloud, hosted on AWS and accelerated by Swarm64 DA. Learn how to use PG Nitrous for query-intensive projects and how it compares to other PostgreSQL cloud options like Amazon RDS.

Modernizing legacy data warehousing with open source PostgreSQL – Dec 03, 2020, 3 pm (CET)

With the arrival of new parallel processing, columnar storage, and indexing extensions, PostgreSQL has become a viable option for analytics & data warehousing. Join PostgreSQL experts from CYBERTEC and Swarm64 to learn about modernizing your SQL data warehouse & analytics platforms with open source PostgreSQL.

PostgreSQL columnstore indexing best practices – Dec 10, 2020, 10 am (PT)

Swarm64 Solution Architect, Sebastian Dressler will explain columnstore indexing best practices to help you get the best query performance out off your Postgres database.

Migrate to PostgreSQL and reduce TCO by 80% – Nov 26, 2020, 3 pm (CET)

Join Cybertec’s webinar to learn more about migration to PostgreSQL, why you should migrate NOW and how CYBERTEC makes the migration as easy, comfortable and efficient as possible.

Nov 23 to 25, 2020: Online Training: Kubernetes in PostgreSQL

Dec 14 to 18, 2020:  Online Training: Administration and performance tuning

Do you have news you’d like us to add? Have feedback? Let us know – marketing@swarm64.com.

Newsletter sign up

Postgres Fast Scans newsletter