CREATE CAST: Casting integer to IP in PostgreSQL
How to store and process IP addresses in an efficient way. To do so PostgreSQL provides us with data types by casting integer.
PostgreSQL: Implicit vs. explicit joins
How to use implicit and explicit joins in PostgreSQL. What are the performance differences between these two types of join?
Google Cloud PostgreSQL under pgwatch2 monitoring
Find out how to monitor PostgreSQL databases on Google Cloud with the pgwatch2 monitoring solution to get extended metrics for added clarity!