Repository files navigation

• PostgreSQL intensive
  • SQL
  • JSON/JSONB
  • QOPT
  • PostgreSQL internal
  • Administration
• DevOps
• Clojure/ClojureScript

PostgreSQL intensive Crash Course by Healt-Samurai

• Query types
• Data types
• Aggregates
• JOINS
• CTE

• Basic operators and functions
• Jsquery
• JsonPath
• Json knife

• MVCC
• Isolation
• Storage
• Toast
• Checkpoints
• Wal

• Query
• Access Methods
  • SEQ scan
  • Index scan
  • Bitmap Index scan
• JOIN
  • Nested loop
  • Hash join
  • Merge join
• GIN index
• Index variation
  • MultiColumnt
  • Partial
  • Functional

• Replication
• Backup and resotre
• Monitoring

⚡ Work In Progress

⚡ Work In Progress