Learn how to install and use the pg_stat_statements extension in Postgres to monitor query performance over time
CREATE VIEW AS SELECT * does not dynamically adjust to the underlying object
It never ceases to amaze me how I can be humbled every day. When you work with a technology for so long, teaching, writing, presenting, training, and mentoring…you start to think you’re an expert. You think by now you know all the basics, advanced aspects and nuances. And yet, despite your experience, there it is:…
BULK COLLECT and COUNT() do not raise NO_DATA_FOUND
I thought I knew bulk operations well. Today, while coding up a quick hunk of PL/SQL, the code did not behave as expected. Basically, I’d had a senior moment and forgotten something that I think my novice DBA and developer readers might benefit from. When you try to select some rows from a data structure…
Dropping a View Drops the Instead-of Triggers
On top of using this blog to speak on data and database design and development, I’ll also be using it as a notebook, documenting the moments of discovery and clarity that occur when dealing with problems. I wish I’d been taking notes this way since I began my career in 1995, instead of just hoping…