HIRONOBU SUZUKI @ INTERDB BLOG

Autovacuum tip

I show a tip of autovacuum management.

As frequently mentioned, the table bloat problem is one of the most annoying things in managing PostgreSQL. Several things can cause that problem, and Autovacuum is one of them.


pg_plan_inspector

I’ve just released pg_plan_inspector that is a framework to monitor and improve the performance of PostgreSQL using Machine Learning methods.

One movie is worth a thousand words. Watch this movie.


Poll: Product Name

I’m developing a new private product, but I’ve not decided the name of it yet. So, I’d like to do a poll about what name is good.

Tweet


SHUTDOWN DATABASE in PostgreSQL

I made a PostgreSQL’s module called shutdown_db using weekend time.

This module emulates the Oracle’s shutdown commands by controlling access for each DB.


How to install and use pgindent

pgindent maintains the uniform layout style of postgresql related source code.