We Need To Talk About Postgres

A talk about an issue we had with our database and how solving it kind of made it worse

Presented at Hong Kong Codeaholics on Wednesday August 10th 2016

Transcript

1. 8F
   OFFE
   UP
   UBML
   BCPVU
   1PTUHSFT )BDLFE
   UPHFUIFS
   UBML
3. 6CFST
   QSPCMFN
   8SJUF
   "NQMJDBUJPO
   PO
   GSFRVFOUMZ
   VQEBUFE
   UBCMFT
5. 8IFO
   0VS
   %#
   "MNPTU
   %JFE
6. UP
   JOOJUZ
   
   CFZPOE
7. JU
   TUBSUFE
   XJUI
   B
   CJH
   EFQMPZ
8. / 
9. TPNF
   TUVQJE
   TUV
10. 1FSGPSNBODF
    XBT
    OF
11. #VU
    UIF
    %#
    XBTOU
12. 4XBQQJOH
14. IUUQUBUJZBOUTDPNQFW
15. 5IF
    $PSF
    2VFSZ
16. 4&-&$5
    
    '30.
    SJEFT
    8)&3&
    TUBUVT
    
    QFOEJOH
    03%&3
    #:
    QJDLVQ@UJNF
    %&4$
    
17. $3&"5&
    */%&9
    JOEFY@SJEFT
    0/
    SJEFT
    64*/(
    #53&&
    
    
    TUBUVT
    
    
    QJDLVQ@UJNF
    %&4$
    
    
18. (SFBU
    JEFB
19. UP
    JOOJUZ
    
    CFZPOE
20. 8SJUF
    "NQMJDBUJPO
21. $3&"5&
    */%&9
    JOEFY@SJEFT
    0/
    SJEFT
    64*/(
    #53&&
    
    
    TUBUVT
    
    
    $)"/(&4
    GSFRVFOUMZ
    
    
    QJDLVQ@UJNF
    %&4$
    
    /FFET
    5P
    SFTPSU
    
    
22. ,JMM
    UIPTF
    JOEFYFT
23. 1PTUHSFT
    5PPMT
24.       
26.       
27. IUUQTHJUIVCDPN EBUBDIPNQEPUMFTCMPC NBTUFSQTRMSD
29. 5IF
    BDUVBM
    DBVTF
30. "O
    VOJOEFYFE
    RVFSZ
    PO
    B
    UJOZ
    UBCMF
    T
    PG
    UJNFT
    QFS
    TFDPOE
31. %PI
32. )PX
    EJE
    JU
    UVSO
    PVU
33. 1SFUUZ
    HPPE
34. 4QJLZ
    CVU
    TBGF