Search Postgresql Archives

regarding isolation between threads

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



This is in continuation of my previous mail:
each thread is using a different pgconn.
 
thanks again
Surabhi Ahuja
 
Dear All,
 
I am stuck in the following scenario:
In a dual processor machine, I am running 5 threads.
each of the threads is calling a particular stored procedure to insert a row in the table.
 
the insertion takes place in a transaction and i have set the transaction level to serializable.
 
However it seems that the insertion is not taking place properly because of the threads.
 
isnt the isolation mainiatined in case of threads?
what is it that I can possibly do to provide isolation amongst threads
 
Please tell, in case I should provide more info in regard to this scenario?
 
Thank You in advance
Regards
Surabhi Ahuja

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux