Fraud Blocker

Why are my postgresql update times getting less timely?

A customer recently questioned me about why a bulk load into a PostgreSQL table continued slowing down over time. They saw that the trigger on the tab…

Continue Reading

Oracle REPLACE function.

The Oracle/PLSQL REPLACE function replaces a sequence of characters in a string with another character set….

Continue Reading

Oracle SUBSTR function.

The Oracle/PLSQL SUBSTR function allows extracting a substring from a string….

Continue Reading

Oracle ABS function.

The Oracle/PLSQL ABS functionreturns the absolute value of a number….

Continue Reading

Oracle VSIZE function.

The Oracle/PLSQL VSIZE function returns the length in bytes for the internal representation of the expression….

Continue Reading

🎉 Thank you for subscribing!

You're now on the list for database FinOps strategies and performance insights.