An XMAX contains what?
- 20 December 2022
- Database Performance ManagementDeep learning
xmaxis an MVCC (Multiversion Concurrency Control) system column in PostgreSQL. The documentation is rather succinct:
> The identity (transaction ID) …
PostgreSQL Full Text Search and Vacuum: What It Has To Do With
What is the relationship between PostgreSQL Full-Text Search and VACUUM? Many people might be surprised to find out that there might even be a relatio…
AVOID “OR” FOR BETTER QUERY PERFORMANCE.
- 19 December 2022
- Machine learningTechnology Business
Of course, there is a need for the OR operator in SQL, so if you can’t avoid it, use it. But you should be mindful of the effects on performance.
I’l…
Postgresql’s Update and AutoVac: A Beginner’s Guide
- 18 December 2022
- Machine learningTechnology Business
It’s surprising how many of the recent PostgreSQL support requests we’ve gotten are about autovacuum and UPDATE in particular. PostgreSQL handles upda…
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…
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!