Fraud Blocker

DATA PREPARATION FOR MACHINE LEARNING

You have probably noticed that artificial intelligence and machine learning are currently popular topics. Absolutely, as it is a very significant issu…

Continue Reading

Avoiding stored procedure calls in PostgreSQL that are not necessary

Almost any common language, like Perl, Python, or C, can be used to write stored procedures in PostgreSQL. Overall, this provides excellent flexibilit…

Continue Reading

POSTGRESQL: EASY DETECTION OF PERFORMANCE PROBLEMS 

Is there a single sizable, significant, and important database that does not occasionally experience performance issues? There are probably not too ma…

Continue Reading

An XMAX contains what?

xmaxis an MVCC (Multiversion Concurrency Control) system column in PostgreSQL. The documentation is rather succinct:

> The identity (transaction ID) …

Continue Reading

Post-process trigger performance information

We came to the conclusion that we shouldn’t worry about it too much and should just make those triggers for the most common “audit fields” type of use…

Continue Reading

🎉 Thank you for subscribing!

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