snaga

Top 10 Reviewers (and more) for this CF. (as of July.9 12:00pm JST)

9 reviews: Robert Haas
8 reviews: Heikki Linnakangas, Andres Freund
7 reviews: Hitoshi Harada
6 reviews: Szymon Guz
5 reviews: Greg Smith, Fabien Coelho
4 reviews: Satoshi Nagayasu, Abhijit Menon-Sen, Jeevan Chalke, Andrew Dunstan
3 reviews: Robins Tharakan, Amit Kapila, Steve Singer, Simon Riggs, Dimitri Fontaine, Fujii Masao, Rushabh Lathia, Dean Rasheed
2 reviews: Fabrízio de Royes Mello, Jeff Janes, Jeff Davis, Álvaro Herrera, Pavel Stehule, Peter Eisentraut, Cédric Villemain

snaga

Top 10 Reviewers (and more) for this CF. (as of July.16 16:00pm JST)

9 reviews: Robert Haas
8 reviews: Heikki Linnakangas
7 reviews: Hitoshi Harada, Andres Freund
6 reviews: Szymon Guz, Greg Smith
5 reviews: Fabien Coelho
4 reviews: Satoshi Nagayasu, Abhijit Menon-Sen, Jeevan Chalke, Andrew Dunstan
3 reviews: Amit Kapila, Steve Singer, Simon Riggs, Dimitri Fontaine, Rushabh Lathia, Dean Rasheed
2 reviews: Robins Tharakan, Fabrízio de Royes Mello, Jeff Janes, Jeff Davis, Álvaro Herrera, Pavel Stehule, Peter Eisentraut, Fujii Masao, Cédric Villemain

snaga

#
# provision file for postgresql93 on vagrant
#
sudo rpm -ivh http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-redhat93-9.3-1.noarch.rpm
sudo yum install -y postgresql93 postgresql93-server postgresql93-contrib postgresql93-libs
sudo -u postgres /usr/pgsql-9.3/bin/initdb -D /var/lib/pgsql/9.3/data --no-locale -E utf-8 -k

sudo /sbin/chkconfig postgresql-9.3 on
sudo /sbin/service postgresql-9.3 start

snaga

testdb=> SELECT name,setting,unit FROM pg_settings;
              name               |                   setting                   | unit
---------------------------------+---------------------------------------------+------
 allow_system_table_mods         | off                                         |
 application_name                | psql                                        |
 archive_command                 | /etc/rds/dbbin/pgscripts/rds_wal_archive %p |
 archive_mode                    | on                                          |
 archive_timeout                 | 300                                         | s
 array_nulls                     | on                                          |
 authentication_timeout          | 60                                          | s

snaga

package EzParallel;

use strict;
use POSIX;

our $pidfile = ".ez.pids";
our $lockfile = ".ez.lock";
our $lock_fh;

sub _log {

snaga

# -*- coding: utf-8 -*-

# EzParallel.py
#
# Copyright(C) 2014 Satoshi Nagayasu
# Copyright(C) 2014 Uptime Technologies, LLC.

import fcntl
from time import strftime, localtime
import os

snaga

#!/bin/sh

# install_pgxl.sh
#
# Copyright(c) 2015 Uptime Technologies, LLC.

PGXL_HOME=/opt/uptime/pgxl
PGXL_DATA=/var/lib/pgxl
PGXC_CTL_HOME=${PGXL_DATA}/pgxc_ctl

snaga

#!/usr/bin/env bash
#
# Postgres-XC Configuration file for pgxc_ctl utility. 
#
# Configuration file can be specified as -c option from pgxc_ctl command.   Default is
# $PGXC_CTL_HOME/pgxc_ctl.org.
#
# This is bash script so you can make any addition for your convenience to configure
# your Postgres-XC cluster.
#

snaga

-- for more details, visit below.
-- http://michael.otacoo.com/postgresql-2/postgres-9-5-feature-highlight-brin-indexes/

\timing
CREATE TABLE brin_example AS SELECT generate_series(1,100000000) AS id;

CREATE INDEX brin_index ON brin_example USING brin(id);
EXPLAIN ANALYZE SELECT id FROM brin_example WHERE id = 52342323;

CREATE INDEX btree_index ON brin_example(id);

snaga

diff -rc pg_filedump-9.3.0.orig/pg_filedump.c pg_filedump-9.3.0/pg_filedump.c
*** pg_filedump-9.3.0.orig/pg_filedump.c        2014-06-11 02:23:06.000000000 +0900
--- pg_filedump-9.3.0/pg_filedump.c     2015-07-03 13:46:07.920639843 +0900
***************
*** 3,9 ****
   *                 formatting heap (data), index and control files.
   *
   * Copyright (c) 2002-2010 Red Hat, Inc.
!  * Copyright (c) 2011-2014, PostgreSQL Global Development Group
   *