Connection Pooling with pgBouncer: A Primer
Imagine that you were running a promotion for your blog or website, and it caught the attention of Sarah Connor, […]
Postgres Triggers: Best Practices and Common Use Cases – PGSQL Phriday #007
PGSQL Phriday #007 – Be the James Bond of your Database – take risks, Create Triggers, and always remember that […]
Nested Composite Data Structures in Postgres
Data nesting is a way of organizing data in a hierarchical or nested structure, where one piece of data is […]
Setting up and Configuring pgBackRest
Introduction Having a strong backup and recovery strategy is crucial for any organization that relies on Postgres as its database […]
Setting up and Configuring pgBarman
As discussed on the Postgres Backup for Peeps blog, here are the basic steps to install and configure Barman for […]
Unveiling the mystery of Postgres Backups for my peeps
Introduction When it comes to backing up PostgreSQL databases, there are several tools available. Three popular ones are pg_basebackup, pgBarman, […]
Six Strategies for Improving Customer Experience (CX) & Customer Success (CS)
Why is Customer Success your golden ticket to business success? In the last post, I shared my interest and learning […]
Face-to-face Event Creates a Global Impact
I recently attended my first tech conference, and here I’ll talk about my experience and takeaways. In conferences like this, […]
Why did I choose Postgres career and how I made it my best decision ever?
Well, just to set the groundwork before going gaga over PostgreSQL, in my previous avatar I was a Data Analyst, […]
Safer Internet Day – The Postgres Way
The Internet is not a SAFE place. PERIOD!Well, YOU can make it Safer! At OpenSource DB, we took the standard […]
pg_backend_memory_contexts
I have always been curious to look at a certain Postgres backend connection’s memory consumption. With this new pg_backend_memory_contexts view, […]
Fetch parameters & metadata datatype of Procedure/Function
In an interesting discussion with one of our Customers’ Development team, a question came up: “Do you have a query […]
PostgreSQL 15 New Features (Part – 2)
This year, PostgreSQL’s major upgrade, pg15 was released on 13th October 2022. Here, we examine some more of the new […]
PostgreSQL 15 New Features (Part – 1)
This year, PostgreSQL’s major upgrade, pg15 was released on 13th October 2022. Here, we examine some of the new features […]