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
http://www.monetdb.org/


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."

Tuesday, January 01, 2013

Announcing pg_part extension, a table partitioning utility for PostgreSQL

I'm pleased to announce my first PostgreSQL extension, pg_part extension, to take advantage of table (range) partitioning on PostgreSQL. In the PostgreSQL world, the table (range) partitioning (a.k.a. Constraint Exclusion) is one of the advantages of PostgreSQL for analytical workloads, but using lots of DDL commands for this purpose still requires some patience. This extension provies several SQL functions to allow users manipulating table partitioning on PostgreSQL without executing DDL commands directly. So, pg_part would make it easier to take advantages of the PostgreSQL table partitioning.

Friday, June 01, 2012

pgstatview: Visualize your PostgreSQL in a minute

As you all may know, understanding activities inside database management system is one of the important, but difficult and painful tasks for DBAs, not only for newbies, but also experienced DBAs. I saw many DBAs struggling with PostgreSQL because of such difficulties.

Today, I'd like to introduce a brand-new tool, pgstatview.
pgstatview, a new visualization tool for PostgreSQL, has been developed to help DBAs and make it easier to understand what is actually going on inside PostgreSQL.

pgstatview allows DBA to visualize database activities with using several metrics both inside and outside PostgreSQL: transaction commit/rollbacks, tuple inserts/updates/deletes, cache hit ratio, bgwriter writes, WAL writes, and so on. You can see some sample reports here: Sample 1, Sample 2.

pgstatview has its unique advantages.