selenamarie

Ideal Postgres environment

Documentation

• Documented replication topology
• Documented network topology
• Documented interface topology - including users, passwords, connection estimates, load balancers, connection proxies
• Documented procedure, schedule for failover and testing
• Documented procedure, schedule for disaster recovery and testing

selenamarie

SQL for reporting queries

Datatypes: JSON, HLL

JSON

• http://www.postgresql.org/docs/9.3/static/functions-json.html

selenamarie

Handbooks:
http://www.quirksmode.org/coh/
https://github.com/jnoller/conference
http://www.ieee.org/conferences_events/conferences/organizers/organizers_manual.html
http://www.ted.com/pages/organize_tedx_event

Event planning software:
http://gigaom.com/2010/07/15/eventware-a-roundup-of-software-for-event-planning/
Open Conference Ware

selenamarie

== PostgreSQL

Braintree
* https://www.braintreepayments.com/braintrust/scaling-postgresql-at-braintree-four-years-of-evolution

Instagram
* http://www.databasesoup.com/2012/04/sharding-postgres-with-instagram.html
* http://media.postgresql.org/sfpug/instagram_sfpug.pdf
* http://instagram-engineering.tumblr.com/post/10853187575/sharding-ids-at-instagram#_=_
* http://instagram-engineering.tumblr.com/post/40781627982/handling-growth-with-postgres-5-tips-from-instagram

selenamarie

Mutton Curry Nachos

• Leftover Mutton Curry (see below)
• Tortilla Chips
• 1/4 cup extra sharp cheddar

Fill a bowl 1/2 way with chips. Grate some cheese on top. Cover with re-heated curry.

Mutton Curry

selenamarie

important assumption: Ensure that the buildid includes the start date for the data you're backfilling. There are some restrictions based on "build date", which is extracted from the buildid, deep in the stored procedures. If your buildid resolves to a date that is prior to the date you're testing, none of the matviews will yield results.

1. Add a fake row to releases_raw

INSERT into releases_raw (product_name, version, platform, build_id, build_type, beta_number, repository, update_channel) VALUES('firefox', '27.0', 'win32', '20140136130000', 'beta', 99, 'mozilla-beta', 'beta');

 product_name | version | platform |    build_id    | build_type | beta_number |  repository  | update_channel | version_build 
--------------+---------+----------+----------------+------------+-------------+--------------+----------------+---------------

selenamarie

#!/usr/bin/env python

from decimal import Decimal, getcontext
from math import factorial

#a = float(500000) # total traffic offered
#n = 10 # number of servers


# 500000 per day

selenamarie

data input:

List of Product Versions

nightly aurora beta release 29.0a1 28.0a2 27.0b 26.0

ADI

selenamarie

We focus on catering to everyone that comes to our classes. We aim for 100% understanding.

We want you to learn from each other. We'd like the people you meet here to be colleagues for the rest of your career, regardless of what you do.

Starting out anything new is very hard. We base our course work on 20+ years of experiencing doing, but not teaching. We have a huge gap to overcome in our teaching. Sometimes, our pacing is off, or our explanations fall flat. Our job is to do better next time; your job is to let us know -- ask questions in class, and tell us after class what doesn't work for you.

Our spaces are designed for learning. Come ready to collaborate with others, try new, difficult and unfamiliar things.

We want you to be confident experimentors who can communicate with other programmers.

selenamarie

WITH j_1 AS (
  SELECT subject
  FROM wb_v_latest_triples a
  WHERE 
  a.predicate = 'type' AND a.obj_value = 'http://indx.ecs.soton.ac.uk/ontology/root-box/#server'
),
WITH j_2 AS (
  SELECT subject
  FROM wb_v_latest_triples a
  WHERE