Latest News
Start your free PG Nitrous Trial Get started ›
Swarm64 & EDB partner to extend Postgres with faster queries Read more ›
Blog Post: Introducing the Swarm64 DA PostgreSQL Settings Advisor Read more ›

March 2021

Welcome to the 5th 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.

PostgreSQL News & Knowledge

Speed up Amazon RDS – TPC-H benchmarking of PG Nitrous as a fast query replica for RDS
We detail the TPC-H query price-performance advantages of using PG Nitrous as a fast-query replica to speed up performance for Amazon RDS applications.

Video: Swarm64 DA columnstore indexes explained
In this two-minute video, Swarm64 CEO and co-founder, Thomas Richter, explains what columnstore indexes are, and how they greatly speed up PostgreSQL queries.

PostgreSQL: analyze and optimizer statistics
Learn more about the way PostgreSQL handles query optimization, with a special focus on statistics. What kinds of statistics does PostgreSQL store and where can they be found?

Postgres: What is a checkpoint?
In this post, CYBERTEC CEO Hans-Jürgen Schönig explains PostgreSQL checkpoints and how to tune them for maximum efficiency.

Our partners at Command Prompt have launched a new podcast
A show dedicated to learning about data and the people behind it through lively conversation, diverse topics, and engaging guest speakers. Listen on Spotify or wherever you get your podcasts.

Swarm64 DA Product News

Swarm64 DA 5.3.1: parallel processing of cursors in PostgreSQL for faster BI tool performance
Solution Architect Sebastian Dressler demonstrates how Swarm64 DA 5.3 enables parallel processing of SQL cursors in PostgreSQL for faster BI tool query performance.

PGNitrous 6.1.0 available on AWS
PG Nitrous 6.1 is released with enhancements that makes it even easier to launch and run a faster PostgreSQL database queries on AWS.

Events

PGConf.Russia: Modernize data warehousing with open source PostgreSQLMar 03 2021, 4 pm UTC+3
Swarm64 VP of Product Marketing, Dr. Yana Krasteva presents the technology trends in PostgreSQL that are making it possible to replace costly legacy analytic and data warehouse databases with free, open source PostgreSQL.

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