joop questions

joop answers

• Average stock history table
• Why does a slight change in the search term slow down the query so much?
• Count total number of duplicate rows in a table
• pg_dump serial datatype issues
• Why does PostgreSQL throw "FULL JOIN is only supported with merge-joinable or hash-joinable join conditions"
• Interview task: check if array consists of pairs in O(n) time and O(1) of additional memory
• Create empty table in postgresql
• Loose index scan in Postgres on more than one field?
• Log Stacktrace of current Python Interpreter via PostgreSQL trigger
• Linear regression with postgres