Merry Christmas!! If you are using SQL Server or Oracle databases, I’m giving away my 1 hour of time for rest of this week for free of cost to discuss how you can save $$$$ by migrating them to PostgreSQL database by keeping same features and achieve better performance. you can shoot an email to email@example.com Happy […]
Running Postgres in Docker
For last six months, I have been working on moving Postgres from bare metal & VM based systems in Docker. As of today, we have migrated a couple of mission critical Postgres DBs (~ 2TB) on to Docker environment. During the migration journey, I have listed down some of the things to consider running Postgres production instances […]
YUM repo location & HTTPS changes for Postgres packages !
As Devrim blogged about Postgres YUM repo changes , I wanted to write down procedure I have to follow this morning 🙂 For example, If you want to update YUM repo for Postgres 9.4 on CentOS x86_64, you can update executing below command: yum localinstall https://download.postgresql.org/pub/repos/yum/9.4/redhat/rhel-6-x86_64/pgdg-centos94-9.4-3.noarch.rpm Now, you can follow normal Postgres version upgrade procedure. […]
Advanced Postgres Monitoring!
Today, I presented at PgOpen 2016 (Postgres conference) in Dallas, TX. Here is the slide deck : [slideshare id=66063373&doc=0b32a8bb-f5b3-4886-bd25-358438dc8f13-160915153052]
Recovering Postgres database from disk level corruption!!
A couple of weeks ago, I had to deal with corrupted Postgres database cluster. At the end, we couldn’t able to recover some of the data but managed to recover most part of it. Having experience working with dozens of database systems, I’m pleasantly surprised to experience resiliency of Postgres database. Kudos to Postgres Development team […]
Analyzing effect on default_statistics_target on ANALYZE
Last week, I received request to increase PostgreSQL’s config parameter default_statistics_target on one of the very large DB clusters. The developers filled a ticket to increase the default_statistics_target to 10,000 at cluster level because one of the queries has started full sequencial scan instead of index scan. By default, Postges cluster sets default_statistics_target to 100 but you can set up to […]