Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VHS4j-0003Qu-To for pgsql-general@arkaria.postgresql.org; Thu, 05 Sep 2013 05:25:50 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VHS4j-000427-CS for pgsql-general@arkaria.postgresql.org; Thu, 05 Sep 2013 05:25:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VHS4h-00040T-KT for pgsql-general@postgresql.org; Thu, 05 Sep 2013 05:25:47 +0000 Received: from hogranch.com ([75.101.82.47]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VHS4d-0002yf-Us for pgsql-general@postgresql.org; Thu, 05 Sep 2013 05:25:47 +0000 Received: from [192.168.0.2] (porker [192.168.0.2]) by hogranch.com (8.11.6/8.11.6) with ESMTP id r855Pal20707 for ; Wed, 4 Sep 2013 22:25:36 -0700 Message-ID: <522815DA.7070300@hogranch.com> Date: Wed, 04 Sep 2013 22:25:46 -0700 From: John R Pierce User-Agent: Mozilla/5.0 (Windows NT 6.2; WOW64; rv:17.0) Gecko/20130801 Thunderbird/17.0.8 MIME-Version: 1.0 To: pgsql-general@postgresql.org Subject: Re: Can you please suggest me some links where I can learn: References: <1C16813DAFF3E44B939586605D40E9F011505B10@ESESSMB107.ericsson.se> In-Reply-To: <1C16813DAFF3E44B939586605D40E9F011505B10@ESESSMB107.ericsson.se> Content-Type: multipart/alternative; boundary="------------070100000808080004040101" X-HawgScanner-Information: Please contact the ISP for more information X-HawgScanner: Found to be clean X-Pg-Spam-Score: -4.3 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org This is a multi-part message in MIME format. --------------070100000808080004040101 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 --------------070100000808080004040101 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit

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

--------------070100000808080004040101--