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

    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.
    bachie
    student
    php&postgresql
    Shizuoka-ken, Japan

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    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.
    Lou
    使大吃一惊
    "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
  •