Profile cover photo
Profile photo
Masahiko Sawada
4 followers
4 followers
About
Posts

Post has attachment
pg_keeper - Simple failover module for PostgreSQL
I introduce a new module for PostgreSQL called pg_keeper I made, here. pg_keeper is a quite simplified failover module based on back ground worker for PostgreSQL. Using this module, you can set up high available replication environment with 1-master and 1-s...
Add a comment...

Post has attachment
Evolution of GIN index - PostgreSQL9.4
0. Introduction PostgreSQL9.4, the latest version of PostgreSQL has been released at 18th Dec, 2014. This changes contain not only various newly functions but also evaluation existing function. One of them, the evolution of that GIN index is used for full t...
Add a comment...

Post has attachment
pg_promoter - A simplified clustering module for PostgreSQL
I introduce a new module for PostgreSQL called pg_promoter I made, here. pg_promoter is a quite simplified clustering module based on back ground worker for PostgreSQL. You can set clustering servers between master, slave 2 servers more easier using by pg_p...
Add a comment...

Post has attachment
GINインデックスの進化 - PostgreSQL9.4
この記事は PostgreSQL Advent Calendar 2014 の12/19担当分です。 昨日の12月18日、ついにPostgreSQL9.4がリリースされました!! 0. はじめに PostgreSQL9.4では様々な新機能が組み込まれたほか、既存機能の進化もありました。 その中でも全文検索等に使われる”GINインデックス”では、 インデックスサイズの縮小 特定ケースでの検索速度向上 の2つの大きな進化がありました。 本記事では、これらの内容について具体的にどのような改善があったかをご紹介いたし...
Add a comment...

Post has attachment
pg_dbms_stats - Fixing relation and column statistics and planning, and managing stable query performance - PostgreSQL
pg_dbms_stats, which is a little popular module in Japan, fix relation(it means table or index) and column statistics, and then make stable query planning. This article mainly shows how to operate it except basically usage with simple scenario as follows. I...
Add a comment...
Wait while more posts are being loaded