Horton

Re: Can you please suggest me some links where I can learn:

John R Pierce <pierce@hogranch.com>

View thread
From: John R Pierce <pierce@hogranch.com>
To: pgsql-general@postgresql.org
Date: 2013-09-05T05:25:46Z
Lists: pgsql-performance 
On 9/4/2013 10:13 PM, M Tarkeshwar Rao wrote:
>
> Can you please suggest me some links where I can learn:
>
> 1.Transaction Isolation in Database
>

the documentation

> 2.Query procession and possible optimizations.
>

the source code.     if there were any easy optimizations, I'm sure 
they've already been taken.

> 3.How to improve query and its performance.
>

see #2 above.

> 4.MVCC in detail.
>

see answer to #1, and the source code if you want more detail.


-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast