Skip to content

codewithgun/learn-postgres

Repository files navigation

Postgres learning

List

  • Vacuum
  • View
  • Materialized View
  • Recursive view
  • Explain, Analyze
  • Indexes
    • B-tree
    • Hash
    • GiST
    • GIN
    • BRIN
    • SP-GiST
  • CTE
  • Concurrency and lock
    • Exclusive vs Shared lock
    • Row level vs Table level lock
  • Recursive CTE
  • Stored Procedure
  • Trigger
  • Listen, Notify
  • Partition
  • Master-slave replication

About

Self study on postgres

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published