Pinned

1. what's locking? what's locking?

   1

   SELECT

   2

       waiting.locktype           AS waiting_locktype,

   3

       waiting.relation::regclass AS waiting_table,

   4

       waiting_stm.query          AS waiting_query,

   5

       waiting.mode               AS waiting_mode,

2. postgres indexes sorted by size postgres indexes sorted by size

   1

   SELECT

   2

       relname AS name,

   3

       pg_size_pretty(sum(relpages::bigint*current_setting('block_size')::bigint)::bigint) AS size

   4

   FROM

   5

       pg_class

3. find parent table of a toast table i... find parent table of a toast table in postgresql

   1

   select

   2

     relname

   3

   from

   4

     pg_class

   5

   where

4. hull moving average hull moving average

   1

   def hma(values, window):

   2

   3

       # requires wma.py

   4

   5

       # HMA = WMA(2*WMA(PRICE, N/2) - WMA(PRICE, N), SQRT(N))

5. weighted moving average weighted moving average

   1

   def wma(values, window):

   2

   3

       # requires trinum.py

   4

   5

       # using definition provided at

6. triangular number triangular number

   1

   def trinum(n):

   2

   3

       # calculates the "triangular number" of a number

   4

       # https://www.mathsisfun.com/algebra/triangular-numbers.html

   5