Thursday, May 21, 2015

[Postgres Toolkit] pt-table-usage/pt-index-usage commands

In this entry, I would like to explain how to use pt-table-usage and pt-index-usage commands in the Postgres Toolkit which I introduced in the previous entry.

If you have never heard about Postgres Toolkit, please visit the previous entry.
pt-table-usage and pt-index-usage are the commands which can be used to obtain usages of the tables/indexes of PostgreSQL.

If you are already familiar with PostgreSQL, you may know that several system views and system tables need to be combined in order to obtain the PostgreSQL statistics and usages.

So, obtaining those information is one of the essential talks for DBA, but it is one of the complicated and bothersome tasks.

pt-table-usage and pt-index-usage are designed to allow DBA to deal with those tasks in single command.

Tuesday, May 12, 2015

Postgres Toolkit 0.2 released

Today, we pleased to announce the release of Postgres Toolkit 0.2.

■What is "Postgres Toolkit"?

Postgres Toolkit is a collection of scripts and utilities which is intended to help PostgreSQL DBA to improve quality and productivity of their daily jobs and operations.

With having Postgres Toolkit, DBA will be able to avoid from writing complicated queries and maintaining their own scripts for their daily operations and do daily DBA jobs. So, the concept of the toolkit is like "A Victorinox for PostgreSQL DBA."

I found this concept when I was sitting with our clients to help them solve PostgreSQL performance issues. At that time, I had no such tool which could help me. I had to write my own several scripts, and it meant someone needed to maintain and support them.

So, I have decided to create "a single solution" which everyone can use anytime everywhere. It is similar to Percona Toolkit for MySQL users, produced by Percona.

Postgres Toolkit 0.2 now supports PostgreSQL 9.0, 9.1, 9.2, 9.3 and 9.4, and can run on Red Hat Enterprise Linux 6 and CentOS 6. Also, it requires Python 2.6 (Python 2.6 is instaled on RHEL6/CentOS6 by default.)

Saturday, June 14, 2014

Deploying Postgres-XL in 2-minutes with Chef/serverspec

As you may know, Postgres-XL, a MPP implementation of PostgreSQL, was released  last month.
Most of recent topics in the PostgreSQL development are related to implementing data warehouse. And Postgres-XL is getting attention.

However, such enhancement which consists of several PostgreSQL servers is a bit difficult to try for newbies because of the complicated deployment procedures.

So, I'd like to introduce a deployment toolkit I have created to deploy and test a "minimal" Postgres-XL cluster. It consists of chef cookbook and serverspec script.

Sunday, July 14, 2013

monetdb_fdw: PostgreSQL meets column store. Finally.

As you may know, FDW is one of the advantages of PostgreSQL. There are variety of FDWs to federate different data sources (including PostgreSQL itself) with PostgreSQL.

And also, you may know everyone in the industry is talking about BigData and analytics everyday. We know that most of them must be a buzz though. :p

Yesterday, I released a brand-new FDW, monetdb_fdw, which allows you to federate MonetDB, an open source column-oriented RDBMS, with PostgreSQL.

The column-store pioneer | MonetDB

MonetDB was originally developed at University of Amsterdam, and it has been well developed and maintained as open source.

Tuesday, February 19, 2013

PostgreSQL Unconference in Tokyo

Last Saturday, we, Japan PostgreSQL Users Group, had the first PostgreSQL "Unconference" in Tokyo.

The event had about 40 participants and 17 talks in 4 hours, and it was successfully run by the participants.

As you may know, "conference" requires its host to arrange the program *much before* the event starts. As opposed to that, "unconference" doesn't.

"Unconference" is filled with many short talks, typically 10 to 20 minute ones, which need to be arranged at beginning of the event, and running multiple (two or more) sessions at the same time to give a chance to participants to find a topic they are interested in.

What we did and what we saw there.

So, I started the event with saying this:

"Welcome to *the most unprepared event* we've ever had! :) Now is the time to start arranging our program. Please write down the title of your talk on the post-it note, and put it on the white board."