Theron Luhn luhn

This was performed on Ubuntu 14.04 with a fresh install of PostgreSQL 9.3.14 directly from the official Postgres apt repo. It only works if the query planner chooses the attached plan (with HashAggregate).

Create and populate a new database:

psql -U postgres -c "create database test;"
psql -U postgres test < populate.sql

Open a connection to the database and execute query.sql. The Postgres worker memory usage will rise approximately 50MB and won't be released until the connection is closed.

	from sqlalchemy import engine_from_config, event
	from sqlalchemy.orm import sessionmaker


	def query_count_hook(
	conn, cursor, statement, parameters, context, executemany,
	):
	info = conn.info
	info['query_count'] = info.get('query_count', 0) + 1

	import functools


	class memoize_method:
	"""
	A decorator to memoize a method. The cache is stored as a dictionary
	inside the object.

	This functionality is similar to stdlib's :func:`functools.lru_cache`.
	When using lru_cache on a method, the object will be used as part of the

	"""
	Code adapted from and inspired by http://blog.ranman.org/cleaning-up-aws-with-boto3/.

	"""
	import os
	import re
	from datetime import datetime, timedelta
	import boto3

	(function() {

	// Inspired by http://informationandvisualization.de/blog/box-plot
	d3.box = function() {
	var width = 1,
	height = 1,
	duration = 0,
	domain = null,
	value = Number;
	showLabels = true, // whether or not to show text labels

	{
	"query": {
	"filtered": {
	"filter": {
	"and": [
	{
	"term": {
	"deleted": false
	}
	},

	#!/bin/sh

	set -e

	touch /tmp/linked
	ln -s /tmp/linked . \|\| true

	cat <<EOF > Dockerfile
	FROM busybox:ubuntu-14.04
	ADD . /data

	from aiopg import Connection as BaseConnection


	class Connection(BaseConnection):
	async def query(self, query, args=[]):
	cur = await self.cursor()
	try:
	await cur.execute(query, args)
	return await cur.fetchall()
	finally:

	@view_config(context=Forbidden, renderer='renderer.pt')
	def forbidden(context, request):
	# If unauthenticated, redirect to sign in
	if(
	Authenticated not in request.effective_principals
	and request.unauthenticated_userid is None
	):
	raise HTTPFound('auth redirect')

	# If unverified and verification would help, redirect to verification

	<?xml version="1.0" encoding="UTF-8"?>
	<!--
	QZ INDUSTRIES SIGNED JNLP FILE
	Author:
	A. Tres Finocchiaro ([email protected])
	Website:
	http://qzindustries.com
	Internal Filename:
	qz-print.jar\JNLP-INF\APPLICATION.JNLP
	External Filename: