Mario Konschake mariokonschake

I hereby claim:

To claim this, I am signing this object:

	SELECT
	(
	(VALUES ((SELECT max(price/20) FROM prices))) * bin
	)::float AS lower_bin_edge,
	COALESCE(count, 0) AS count
	FROM (
	SELECT
	floor(
	price /
	(VALUES ((SELECT max(price/20) FROM prices)))

	L1 cache reference 0.5 ns
	Branch mispredict 5 ns
	L2 cache reference 7 ns
	Mutex lock/unlock 25 ns
	Main memory reference 100 ns
	Compress 1K bytes with Zippy 3,000 ns
	Send 2K bytes over 1 Gbps network 20,000 ns
	Read 1 MB sequentially from memory 250,000 ns
	Round trip within same datacenter 500,000 ns
	Disk seek 10,000,000 ns

	#/bin/bash

	echo "copy ($@) to stdout with CSV HEADER;" \| psql