Heikki Rauhala hvrauhal

How to identify my most expensive queries using pg_stat_statements

First enable the library for the server by adding the following line to postgresql.conf:

shared_preload_libraries = 'pg_stat_statements'

If you've installed postgresql with homebrew, the configuration file is at /usr/local/var/postgres/postgresql.conf

Then enable the extension for the databases that you're interested in with

Bulk File Transfer From HFS+ usb drive to Windows 10 NTFS disk

Why not just copy via SMB?

First I tried to just copy the contents from an SMB share running on MacOS side. That was super slow, and considering also the impossibility of resuming, or knowing what actually got transferred, I did not think that would be the route to go.

Next I tried to naively rsync over an SMB mounted windows drive from the MacOS side, but the problem is that the local diff algorithm does not work over network, as all the data is transferred to the same process for comparison, and even skipping the rsync algorithm, the transfer speed was really low.

I have previously fought with ssh to get it to transfer files at full speed and decided to skip that battle this time.

	var Promise = require('bluebird');

	var funcs = Promise.resolve([100, 200, 300, 400].map((n) => makeWait(n)));

	console.log('first with {concurrency: 1}');
	funcs
	.map(iterator, {concurrency: 1})
	.then(function(r) { console.log('Resolved with', r) } )
	.then(function() {
	console.log('then with mapSeries');

	drop table if exists gist_test;
	create table gist_test (
	bar text,
	foo text,
	constraint gist_test_bar_unique unique (bar),
	constraint gist_test_foo_gist_unique exclude using gist (foo with =)
	);
	insert into gist_test (bar, foo) values ('bar', 'foo');
	insert into gist_test (bar, foo) values ('baz', 'foo')
	on conflict on constraint gist_test_bar_unique

	#!/bin/zsh
	# brew install ffmpeg
	set -e
	FILENAME=$1
	echo "Recompressing $FILENAME"
	VIDEO_BITRATE=512k

	ffmpeg -i ${FILENAME} -codec:a copy -y -c:v libx264 -preset veryslow -b:v ${VIDEO_BITRATE} -pass 1 -f mp4 /dev/null && \
	ffmpeg -i ${FILENAME} -codec:a copy -c:v libx264 -preset veryslow -b:v ${VIDEO_BITRATE} -pass 2 ${FILENAME}_compressed.mp4

	pragma solidity ^0.4.23;

	contract BreakpointSample {
	address public owner;
	uint256 public blockNumberToUnlock;

	constructor (address _owner, uint256 blocksToUnlock) public {
	if (_owner == address(0)) {
	owner = msg.sender;
	} else {

	#!/usr/bin/env python3
	import argparse
	import csv
	import subprocess
	from pathlib import Path


	def create_sounds(sdcard_path: Path, voice: str, lang: str):
	path_to_system = sdcard_path / 'SOUNDS' / lang / 'SYSTEM'
	with (next(path_to_system.glob('*-taranis.csv')).open(newline='')) as csvfile:

	#!/usr/bin/env bash

	set -euo pipefail
	IFS=$'\n\t'

	# Audio generation

	python3 - << EOF
	import subprocess