Month: January 2018
Avoiding unnecessary function calls in PostgreSQL
It is possible to write functions in PostgreSQL in almost any widespread language such as Perl, Python or C. In general this offers a great deal of flexibility and acceptable performance. However, in some cases customers might say: “We have the feeling that procedures are slow”. The thing is: PostgreSQL might not be to blame […]
Cybertec pgconfigurator: Configuring PostgreSQL visually
Configure PostgreSQL quickly and easily We are proud to announce the release of our latest tool to the PostgreSQL community: the CYBERTEC pgconfigurator, a visual tool for configuring PostgreSQL. We know that many people want a visual tool to configure PostgreSQL database servers. CYBERTEC’s pgconfigurator quickly determines the most important config parameters to be used […]
How a bad network configuration can cause table bloat
(Updated 2023-04-20) I recently had an interesting support case with table bloat that shows how the cause of a problem can sometimes be where you would least suspect it. Note: the problem I describe in this article can only occur in PostgreSQL v14 and below, since the statistics collector has been rewritten in v15. About […]
Preparing data for machine learning in PostgreSQL
You have probably noticed that everyone is talking about Artificial Intelligence and Machine Learning these days. Quite rightly, because it is a very important topic, which is going to shape our future for sure. However, when looking at most of the code related to machine learning available on the net, it strikes me, how much […]
ALTER TABLE: High-Availability taken care of
High availability in PostgreSQL: When running an application in production, it might happen that the data structure has to be changed once in a while. Adding columns, dropping columns, etc. might simply be necessary once in a while. However, changing data structures should not be done mindlessly – there are some things you have to […]