Welcome to our latest podcast episode, where we're thrilled to introduce our distinguished guest, Vikas Agarwal. Currently serving as the Vice President of Engineering at Citizens Bank, Vikas is at the forefront of revolutionizing the bank's database landscape. His expertise encompasses a broad spectrum of responsibilities, including Database Engineering, Support, Architecture, and Delivery.  Prior to joining Citizens Bank, Vikas honed his skills as an Engineering Manager at Amex, where he spearheaded the comprehensive DBaaS (Database as a Service) initiative. Vikas's technical prowess ..read more

Know Our Guest In 1997, Joshua Drake embarked on a pioneering journey in the database world by establishing Command Prompt, Inc, renowned as the longest-standing and original Postgres service provider still in operation. A decade later, he launched the Postgres Conference, which has grown to become the world's largest non-profit event focused on Postgres, celebrating its community and advancements. Further extending his influence in 2008, Joshua initiated United States PostgreSQL, a 501c3 organization aligned with PostgreSQL.Org in the United States. His entrepreneurial spirit didn't stop t ..read more

Hello, and welcome to a free monthly edition of my newsletter. I’m Ajay, and each week I tackle reader questions about PostgreSQL, working and implementing PG with best practices, and anything else that’s stressing you out in the PostgreSQL world. Send me your questions and in return, I’ll humbly offer actionable real-talk advice. ?? If you find this post valuable, check out some of my other posts: PostgreSQL Performance and Tuning: How to Optimize Database for High Performance How to decide your PostgreSQL backup strategy? Index Corruption in PostgreSQL: The Hidden Cost To receive thi ..read more

Hello, and welcome to a free monthly edition of my newsletter. I’m Ajay, and each week I tackle reader questions about PostgreSQL, working and implementing PG with best practices, and anything else that’s stressing you out in PostgreSQL world. Send me your questions and in return, I’ll humbly offer actionable real-talk advice. ?? If you find this post valuable, check out some of my other posts: PostgreSQL Performance and Tuning: How to Optimize Database for High Performance How to decide your PostgreSQL backup strategy? Index Corruption in PostgreSQL: The Hidden Cost To receive this ne ..read more

Hello, and welcome to a free monthly edition of my newsletter. I’m Ajay, and each week I tackle reader questions about PostgreSQL, working and implementing PG with best practices, and anything else that’s stressing you out in PostgreSQL world. Send me your questions and in return, I’ll humbly offer actionable real-talk advice. ?? If you find this post valuable, check out some of my other posts: How to decide your PostgreSQL backup strategy? Index Corruption in PostgreSQL: The Hidden Cost How To Monitor PostgreSQL Like a Boss!! To receive this newsletter in your inbox weekly, consider s ..read more

Hello, and welcome to a free monthly edition of my newsletter. I’m Ajay, and each week I tackle reader questions about PostgreSQL, working and implementing PG with best practices, and anything else that’s stressing you out in PostgreSQL world. Send me your questions and in return, I’ll humbly offer actionable real-talk advice. ?? If you find this post valuable, check out some of my other posts: How to decide your PostgreSQL backup strategy? Index Corruption in PostgreSQL: The Hidden Cost How To Monitor PostgreSQL Like a Boss!! To receive this newsletter in your inbox weekly, consi ..read more

A corruption in the database base often manifests itself in the form of errors when performing a DDL or DML operation on affected relations. The errors often show up as errors reading tables due to a missing file—that is rather straightforward, of course. However, a corrupt index is not as obvious as a corrupt table. More often than not to find if indeed there is index corruption, one needs to observe the behavior (execution times) and results of the queries themselves. What are some of the symptoms of a corrupt index you might see in a database? A. Queries that use indexes are performing m ..read more

If you’re currently running an Oracle database and are considering migrating to PostgreSQL, this guide is for you. We’ll cover everything you need to know about the migration process, from planning to execution. By the end of this guide, you’ll be equipped with all the knowledge necessary to make a smooth transition from Oracle to PostgreSQL. Why migrate from Oracle to PostgreSQL? PostgreSQL offers superior performance and scalability compared to Oracle. PostgreSQL offers more advanced features and capabilities than Oracle, including JSON support, geospatial data types, and more. Post ..read more

The database is the heart of the application. Before we dig into some insights about why it’s essential to monitor Postgres, we’ll first discuss a bit about monitoring. Monitoring is collecting historic data points that you then use to generate alerts (for any anomalies), to optimize your database, and lastly to be proactive in case something goes wrong (for example, a failing database).  The “We will see when it happens” approach might work with your personal projects, but can cost significant money for an enterprise if not paid attention to. While it is essential to monitor your databas ..read more

PostgreSQL is an awesome database that has a lot of cool features for developers. In this blog post, we'll talk about 10 of the most important features of PostgreSQL that every developer should know. These features will help you build amazing apps that are fast, reliable, and secure. We'll also provide some helpful links to documentation and other resources that you can use to learn more about PostgreSQL. By the end of this blog post, you'll have a much better understanding of what PostgreSQL can do and how it can help you create awesome apps. Support for a wide range of data types Robust ..read more