Select Page

Blog

Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.

Category:

A PostgreSQL 13 Feature Deep-dive

PostgreSQL is an open-source relational database solution known for delivering powerful functionality. Here’s a look at the newest additions in PostgreSQL 13.

Shailesh Rangani | May 4, 2021

The Risk of Running Legacy Database Technology

End of life comes for most technology, databases being no exception. Learn more about the risks of running legacy database technology.

Shailesh Rangani | April 8, 2021

Which PostgreSQL Upgrade Option Should You Choose?

When you’re upgrading PostgreSQL, you have two methods. Properly preparing for the upgrade and selecting the right choice depends on understanding the options.

Shailesh Rangani | March 25, 2021

10 Best Practices to Secure PostgreSQL AWS RDS/Aurora

Follow these 10 best practices in order to secure PostgreSQL AWS RDS/Aurora.

Shailesh Rangani | July 21, 2020

PostgreSQL Indexing Types: How, When & Where Should They Be Used?

New blog post lays out what are indexes supported by PostgreSQL following with when to use which type of index.

Shailesh Rangani | July 15, 2020

AWS IAM to Authenticate Against RDS Instances & Aurora Clusters

Authenticate your RDS instance or Aurora cluster without a password using AWS IAM. It works for PostgreSQL and MySQL databases on RDS.

Shailesh Rangani | February 26, 2020

Analyzing PostgreSQL RDS Workload with pgbadger

New blog post lays out the steps to help you analyze your PostgreSQL RDS workload with pgbadger.

Shailesh Rangani | January 29, 2020

Rotate Your TLS-SSL Certificate on RDS-Aurora Before February

AWS provides CA certificate for connecting to RDS instance using SSL/TLS. This certificate gets rotated frequently as part of ongoing maintenance and best practices.

Shailesh Rangani | January 16, 2020