Skip to content

Latest commit

 

History

History
18 lines (14 loc) · 1.16 KB

README.md

File metadata and controls

18 lines (14 loc) · 1.16 KB

PostgreSQL

This repository has detailed description of the changes made to postgres-master repository as well as some other concepts that we are trying to highlight. Please refer Read-ME Folder for Complete details regarding each topic.

Postgres_Installation: About Postgres and Installation of Postgres in Ubuntu 14.04
Index_Comparison: Comparison between Hash Index and B-tree index (The index creation time and time taken to search for records using indexes) with benchmark
MVCC: Implementation of how MVCC works in Postgres and variations in the different features supported by it. (How Concurrency is controlled internally)
Deadlocks: Deadlock and how Deadlock detection/correction mechanism works in Postgres
Debug_Postgres_GDB: A Brief Manual on how to attach GDB Debugger to postgres and use it.
Selectivity: When to use Indexes vs when not to
Buffer_Replacement_Policies: A guide to implement buffer replacement policies (LRU, MRU, Clock, 2Q) in Postgres.

Youtube: https://www.youtube.com/watch?v=JALu5dvNbCY

Presentation: https://prezi.com/kxjj7glpe-13/postgres-team/