PostgreSQL Database

  1. Transactions and Concurrency Control
    1. ACID Properties
      1. Atomicity
        1. Consistency
          1. Isolation
            1. Durability
            2. Transaction Control
              1. BEGIN Transaction
                1. START TRANSACTION
                  1. COMMIT
                    1. ROLLBACK
                      1. SAVEPOINT
                        1. RELEASE SAVEPOINT
                          1. Transaction Blocks
                          2. Concurrency and Locking
                            1. Multi-Version Concurrency Control
                              1. Lock Types
                                1. Row Locks
                                  1. Table Locks
                                    1. Advisory Locks
                                    2. Lock Modes
                                      1. Shared Locks
                                        1. Exclusive Locks
                                        2. Deadlocks
                                          1. Detection
                                            1. Resolution
                                            2. Lock Monitoring
                                            3. Transaction Isolation Levels
                                              1. READ UNCOMMITTED
                                                1. READ COMMITTED
                                                  1. REPEATABLE READ
                                                    1. SERIALIZABLE
                                                      1. Isolation Phenomena
                                                        1. Dirty Reads
                                                          1. Non-repeatable Reads
                                                            1. Phantom Reads

                                                        Previous

                                                        6. Indexes and Performance

                                                        Go to top

                                                        Next

                                                        8. Procedural Programming and Functions