Tag: tag

PostgreSQL performance diagram: parallel seq scan vs index scan impact on cache hit ratio

Why PostgreSQL Cache Hit Ratio Keeps Dropping: The Missing Index Problem

Posted on by sanjeeva

Recently, we encountered a perplexing situation with one of our production PostgreSQL systems. The buffer cache hit ratio, which had been consistently above 95%, started gradually declining – hovering around 90% and continuing to drop. The strange part? No slow query alerts, no CPU saturation, no memory pressure warnings. Everything looked normal on the surface. Read more about Why PostgreSQL Cache Hit Ratio Keeps Dropping: The Missing Index Problem[…]

Oracle CDB architecture showing pluggable database DATAPDB being dropped with datafiles - Oracle 19c multitenant illustration

How to Drop a Pluggable Database Including Datafiles in Oracle 19c

Posted on by sanjeeva

Last month, I needed to decommission a development PDB that was consuming valuable storage on our production CDB. The challenge? Ensuring all datafiles were completely removed without affecting other PDBs in the container. If you’ve ever hesitated before dropping a PDB—worried about orphaned datafiles or accidentally keeping files you meant to delete—this guide walks you Read more about How to Drop a Pluggable Database Including Datafiles in Oracle 19c[…]