uptime.jp

pgsnaga.blogspot.com

A Hacker's Diary: Deploying Postgres-XL in 2-minutes with Chef/serverspec

http://pgsnaga.blogspot.com/2014/06/deploying-postgres-xl-in-2-minutes-with.html

Some thoughts around PostgreSQL and OpenSource. 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. Postgres-XL Open Source Scalable SQL Database Cluster http:/ www.postgres-xl.org/. Most of recent topics in the PostgreSQL development are related to implementing data warehouse. And Postgres-XL is getting attention. There are a few assumptions to install Postgres-XL with this toolkit.

pgsnaga.blogspot.com

A Hacker's Diary: July 2013

http://pgsnaga.blogspot.com/2013_07_01_archive.html

Some thoughts around PostgreSQL and OpenSource. 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. The column-store pioneer MonetDB. Http:/ www.monetdb.org/.

pgsnaga.blogspot.com

A Hacker's Diary: May 2010

http://pgsnaga.blogspot.com/2010_05_01_archive.html

Some thoughts around PostgreSQL and OpenSource. Saturday, May 15, 2010. 5 steps to implement a PostgreSQL replication system. Yesterday, I tried to build a PostgreSQL master-slave replication system with new feature Streaming Replication (SR), which is coming in the next PostgreSQL major release 9.0 as a built-in replication solution, and it worked well on my servers. I feel it is very easy to configure, so I have decided to make some memos here for building a PostgreSQL master-slave replication system.

pgsnaga.blogspot.com

A Hacker's Diary: March 2012

http://pgsnaga.blogspot.com/2012_03_01_archive.html

Some thoughts around PostgreSQL and OpenSource. Tuesday, March 06, 2012. Japan PostgreSQL Users Group received Achievement Award 2011 from DBSJ. Today, Japan PostgreSQL Users Group (JPUG) has been awarded Achievement Award 2011 from the Database Society of Japan (DBSJ), the largest (umbrella) database research community in Japan, because of its activities on database research, educating engineers and promoting database technology in Japan. Posted by Satoshi Nagayasu. Subscribe to: Posts (Atom).

pgsnaga.blogspot.com

A Hacker's Diary: PostgreSQL Unconference in Tokyo

http://pgsnaga.blogspot.com/2013/02/postgresql-unconference-in-tokyo.html

Some thoughts around PostgreSQL and OpenSource. 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. What we did and what we saw there. It was v...

pgsnaga.blogspot.com

A Hacker's Diary: Postgres Toolkit 0.2 released

http://pgsnaga.blogspot.com/2015/05/postgres-toolkit.html

Some thoughts around PostgreSQL and OpenSource. Tuesday, May 12, 2015. Postgres Toolkit 0.2 released. Today, we pleased to announce the release of Postgres Toolkit 0.2. Http:/ www.github.com/uptimejp/postgres-toolkit/. Https:/ postgres-toolkit.readthedocs.org/. 9632;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. 9632;What does Postgres Toolkit contain?

pgsnaga.blogspot.com

A Hacker's Diary: January 2013

http://pgsnaga.blogspot.com/2013_01_01_archive.html

Some thoughts around PostgreSQL and OpenSource. Tuesday, January 01, 2013. Announcing pg part extension, a table partitioning utility for PostgreSQL. Im pleased to announce my first PostgreSQL extension, pg part extension, to take advantage of table (range) partitioning on PostgreSQL. Https:/ github.com/uptimejp/pg part. PostgreSQL: Documentation: 9.1: Partitioning. Http:/ www.postgresql.org/docs/9.1/static/ddl-partitioning.html. Posted by Satoshi Nagayasu. Subscribe to: Posts (Atom).

pgsnaga.blogspot.com

A Hacker's Diary: June 2014

http://pgsnaga.blogspot.com/2014_06_01_archive.html

Some thoughts around PostgreSQL and OpenSource. 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. Postgres-XL Open Source Scalable SQL Database Cluster http:/ www.postgres-xl.org/. Most of recent topics in the PostgreSQL development are related to implementing data warehouse. And Postgres-XL is getting attention. Posted by Satoshi Nagayasu. Subscribe to: Posts (Atom).

pgsnaga.blogspot.com

A Hacker's Diary: [Postgres Toolkit] pt-table-usage/pt-index-usage commands

http://pgsnaga.blogspot.com/2015/05/pt-table-usage-pt-index-usage.html

Some thoughts around PostgreSQL and OpenSource. 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. A Hacker's Diary: Postgres Toolkit 0.2 released. Here is an example that shows usage of the tables in the postgres database. Also access st...