xlogdump 0.5.0 released

Hi, pg folks,

xlogdump is a tool for extracting data from WAL segment files. I'm pleased to announce the latest version of xlogdump, 0.5.0, after a few weeks from the previous release 0.4.0.

I think xlogdump would be helpful to understand PostgreSQL behaviors, and you can enjoy brand-new features in this version, so please try it if you're interested in it.

In this version 0.5.0, xlogdump is able to show not only xlog records itself, but also the statistics of xlog records as the right pic.

xlogdump 0.4.0

I'm pleased to announce the latest release of xlogdump. xlogdump is a tool for extracting data from WAL segment files.

Here is xlogdump README:
https://github.com/snaga/xlogdump/blob/master/README.xlogdump

xlogdump was originally developed by Tom Lane and Diogo Biazus around five years ago, but not be maintained these few years.

PostgreSQL Query Cache - "pqc"

I would like to introduce a new open source software, PostgreSQL Query Cache, which enables to improve query performance extremely (10x~100x) by caching query results in front of backends.

PostgreSQL Query Cache:

• waits connections on the different port from the clients.
• delegates queries in front of the backends, like a proxy.
• intercepts and caches SELECT query results.
• also manages lifecycle of the query cache.

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.

Here are 5 steps to implement a PostgreSQL replication system.

1. Build and install binaries.
2. Initialize a database cluster and duplicate it.
3. Configure the master node.
4. Configure the slave node(s).
5. Start the master and slave node(s).

Ok, let's start.

(This photo was taken at the PostgreSQL 9 TestFest Japan.)

PostgreSQL 9 TestFest Japan on Apr.4

Some Japanese PostgreSQL developers are inspired by the SFPUG’s TestFest announce, and we are now planning to have our TestFest at 3am-10am Apr.4 in Tokyo/Japan, which is equivalent to 11am-6pm Apr.3 PST in SanFrancisco.

PostgreSQL 9 is going to be a very exciting release, and we hope to try many new things around PostgreSQL 9. So we have decided to have our TestFest as an all-night event, like a hackathon.