Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2005

    Unanswered: Locking System using PostgreSQL

    Im planning to create a small ordering system using mobile phone internet. I want to control the concurrent access in my database.

    I read about Row Level Locks but there is no any situational example. And also I read regarding of the use of locks in database system conflicts.

    Please give me an idea.. or its highly appreciated in advance if you give me the guidelines to implement locking system.

    Thanks guys.
    Shizuoka-ken, Japan

  2. #2
    Join Date
    Jun 2004
    Arizona, USA
    Why would you want to use row level locking rather than PostgreSQL's native Multi-Version Concurrency Control (MVCC?) MVCC will give you better performance and better scalability than row locking. Plus, it's easier to work with.
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts