Understanding Partition Elimination in PostgreSQL 11
This is Part-III for my series on Postgres Table partitioning. I’ll encourage you to also read Part-I and II on this topic.
Continue reading “PostgreSQL Table Partitioning Part III – Partition Elimination”
It’s been some time since I’ve blogged, even though I’ve been reading a lot all this while. One of the reason is that I couldn’t find enough compelling topics to write and share. Microsoft has been moving too fast with their SQL Server releases (2012, 2014, 2016….and we’re talking Linux beta right now) and I’ve always been catching up.
However, between all this, something has changed. Due to an ever-growing buzz around Open Source, I haltingly started looking into PostgreSQL. Truth be told, I’m starting from ground zero (so nothing to loose) and will be writing on topics that might sound too simple for some of you, nevertheless you may still find ’em helpful.
Continue reading “Learning beyond SQL…PostgreSQL – Indexes”
One of regular issues DBA’s get are about the T-log growth. Situations, wherein one “bad” or “poorly-designed” query can eat up entire T-log space, bring the free space to zero and then bring your application down. The cause and remedy of most these issue is discussed in this KB # 317375(I’m big fan on Microsoft KB’s).
Continue reading “Identify queries that consume a large amount of log space in SQL Server”