There is unfortunately no best practice when you should execute “VACUUM FULL”. The extension pg_freespacemap however gives you suggestion.
At the end of 2014, I was shocked at the progress of blind deblurring algorithm, so I studied the recent researches in this field.
I read many papers and made a system based on this paper: “Blind deconvolution using alternating maximum a posteriori estimation with heavy-tailed priors”.
I always use my customized statistics views shown below because the original ones provide only minimum information.
I show my tools in this post.
Many people around the world admire the Uber’s article “Why Uber Engineering Switched from Postgres to MySQL”, but I think this article contains many mistakes. So, I’m going to provide correct information regarding to PostgreSQL and MySQL.
In this post, I explain the replication of both databases.
In this week end, I tested PostgresPro’s pg_arman with ptrack. Speaking from the conclusion, it works well.
I made a CentOS vagrant box which contains GNOME desktop environment, so I will show how to use and to make it.
I found an interesting quiz about PLpgSQL.
Though I had forgotten this work for a long time, I found its executable files from my old PC a month ago (unfortunately the source code of them was lost). They perfectly run, so I provide a Vagrant box to run my old program on your PC.