sourcesmith

Hey! I saw this has been indexed by the search engines. It is a first draft of a post I ended up publishing on my blog at: Scaling PostgreSQL With Pgpool and PgBouncer

Thanks for stopping by!

PostgreSQL and Pgpool Architecture

	# You will need latest NVIDIA drivers installed. At the time of writing, version is 331.20.
	# On ubuntu 13.10, it looks like this:
	sudo add-apt-repository ppa:xorg-edgers/ppa
	sudo apt-get update
	sudo apt-get install nvidia-331

	# Now we need to install bumblebee:
	sudo add-apt-repository ppa:bumblebee/stable
	sudo apt-get install bumblebee bumblebee-nvidia bbswitch-dkms

	WITH btree_index_atts AS (
	SELECT nspname, relname, reltuples, relpages, indrelid, relam,
	regexp_split_to_table(indkey::text, ' ')::smallint AS attnum,
	indexrelid as index_oid
	FROM pg_index
	JOIN pg_class ON pg_class.oid=pg_index.indexrelid
	JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace
	JOIN pg_am ON pg_class.relam = pg_am.oid
	WHERE pg_am.amname = 'btree'
	),

	#
	# CORS header support
	#
	# One way to use this is by placing it into a file called "cors_support"
	# under your Nginx configuration directory and placing the following
	# statement inside your location block(s):
	#
	# include cors_support;
	#
	# As of Nginx 1.7.5, add_header supports an "always" parameter which

	#!/bin/bash
	#title :wildfly-install.sh
	#description :The script to install Wildfly 10.x
	#more :http://sukharevd.net/wildfly-8-installation.html
	#author :Dmitriy Sukharev
	#date :2016-06-18T02:45-0700
	#usage :/bin/bash wildfly-install.sh
	#tested-version1 :10.0.0.CR3
	#tested-distros1 :Ubuntu 15.10; Debian 7,8; CentOS 7; Fedora 22
	#tested-version2 :10.0.0.Final

	CREATE UNLOGGED TABLE exclude_test(id integer primary key);
	INSERT INTO exclude_test(id) SELECT generate_series(1,50000);

	CREATE UNLOGGED TABLE exclude AS SELECT x AS item FROM generate_series(1,40000,4) x;

	-- Horrific AND list, takes 80s to plan and execute here:

	EXPLAIN ANALYZE SELECT id FROM exclude_test WHERE id <> 1 AND id <> 5 AND id <> 9 AND id <> 13 AND id <> 17 AND id <> 21 AND id <> 25 AND id <> 29 AND id <> 33 AND id <> 37 AND id <> 41 AND id <> 45 AND id <> 49 AND id <> 53 AND id <> 57 AND id <> 61 AND id <> 65 AND id <> 69 AND id <> 73 AND id <> 77 AND id <> 81 AND id <> 85 AND id <> 89 AND id <> 93 AND id <> 97 AND id <> 101 AND id <> 105 AND id <> 109 AND id <> 113 AND id <> 117 AND id <> 121 AND id <> 125 AND id <> 129 AND id <> 133 AND id <> 137 AND id <> 141 AND id <> 145 AND id <> 149 AND id <> 153 AND id <> 157 AND id <> 161 AND id <> 165 AND id <> 169 AND id <> 173 AND id <> 177 AND id <> 181 AND id <> 185 AND id <> 189 AND id <> 193 AND id <> 197 AND id <> 201 AND id <> 205 AND id <>

	[alias]
	l = log --date-order --date=iso --graph --full-history --all --pretty=format:'%x08%x09%C(red)%h %C(cyan)%ad%x08%x08%x08%x08%x08%x08%x08%x08%x08%x08%x08%x08%x08%x08%x08 %C(bold blue)%aN%C(reset)%C(bold yellow)%d %C(reset)%s'

	import java.util.*;
	import java.io.*;
	import java.security.*;

	public class ChangePassword
	{
	private final static JKS j = new JKS();

	public static void main(String[] args) throws Exception
	{

	#! /usr/bin/env python
	from boto.ses.connection import SESConnection
	import os
	import sys
	import subprocess
	import socket

	TMPFILE = '/var/run/postgresql/last-wal-archive-error-file.tmp'

	if __name__ == '__main__':