Serhii Stryzhevskyi Stryzhevskyi

Stryzhevskyi / faces.json

Created October 22, 2016 21:47 — forked from joakin/faces.json

ascii art (faces and stuff)

Stryzhevskyi / instragram_next_id.sql

Created October 14, 2016 21:57 — forked from brent-hoover/instragram_next_id.sql

Instagram's sharding function. (see http://instagram-engineering.tumblr.com/post/10853187575/sharding-ids-at-instagram for explanation)

	CREATE OR REPLACE FUNCTION insta5.next_id(OUT result bigint) AS $$
	DECLARE
	our_epoch bigint := 1314220021721;
	seq_id bigint;
	now_millis bigint;
	shard_id int := 5;
	BEGIN
	SELECT nextval('insta5.table_id_seq') %% 1024 INTO seq_id;

	SELECT FLOOR(EXTRACT(EPOCH FROM clock_timestamp()) * 1000) INTO now_millis;