PostgreSQL Services & Support
CYBERTEC on Teie professionaalne partner PostgreSQL-i tugiteenuste, konsultatsioonide ja koolitusteni.
Meie PostgreSQL-i teenused
Meie kursused ja koolitused
Meie tooted & tööriistad
Meie rahulolevate klientide tagasiside
Uudised CYBERTECi PostgreSQL-i blogist
Transaction ID wraparound: a walk on the wild side
© Laurenz Albe 2022 Most people are aware of transaction ID wraparound. The concept has been well explained in Hans’ article, so I won’t repeat all that here. But for most people it is an abstract concept, a bogeyman lurking in the dark around the corner. Many people know horror stories about anti-wraparound autovacuum tanking […]
A unique constraint where NULL conflicts with everything
© Laurenz Albe 2022 I have been faced with a request for an unusual unique constraint that puzzled me for a while. Since the solution I came up with is a nice show-case for range data types, I’ll share it with you. Also, it allows me to rant some about NULL, which is a temptation […]
usql: universal psql?
usql? But why? usql is a universal command-line interface for many database. But why are we still using CLI (command line utilities) in the 21st century? And what is wrong with psql? Despite the widespread availability and ease of use of GUI-based tools, many people still prefer to use command line utilities for a number […]