Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VHf0O-0007mn-LX for pgsql-general@arkaria.postgresql.org; Thu, 05 Sep 2013 19:14:12 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VHf0N-0004fa-MR for pgsql-general@arkaria.postgresql.org; Thu, 05 Sep 2013 19:14:11 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VHbfm-0006E7-45 for pgsql-general@postgresql.org; Thu, 05 Sep 2013 15:40:42 +0000 Received: from nm37-vm4.bullet.mail.bf1.yahoo.com ([72.30.238.204]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VHbfe-0004R0-SD for pgsql-general@postgresql.org; Thu, 05 Sep 2013 15:40:41 +0000 Received: from [98.139.212.147] by nm37.bullet.mail.bf1.yahoo.com with NNFMP; 05 Sep 2013 15:40:33 -0000 Received: from [98.139.212.230] by tm4.bullet.mail.bf1.yahoo.com with NNFMP; 05 Sep 2013 15:40:33 -0000 Received: from [127.0.0.1] by omp1039.mail.bf1.yahoo.com with NNFMP; 05 Sep 2013 15:39:32 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 844815.56714.bm@omp1039.mail.bf1.yahoo.com Received: (qmail 10070 invoked by uid 60001); 5 Sep 2013 15:39:32 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ymail.com; s=s1024; t=1378395572; bh=MONsS1+amck46JrOS3pOWQ7B2CILoKKpuSk60YFs0s8=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=VAAY/sf4cE24VbLPG7KxvdE08Y2NLnk20aX5YljEKCqO0uT8ZqXlKlPSIJF2Os0rqP+FYChhi0I5v4V0pZ1e5RENQi1xrAVVc7oJid0wpQhCtDjaXY/0Tade+8my0yPCqXQySBC32G9p97CWr8PL1WeSE4YTkseJtIMTBH36f9Y= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=LpxnbflbiiWK+dUAcHw1WAKzxEI/Gceu3ZjvylBZk36fKplrDLgK1q6HJugscA01k5z7XhBCYF1cBedNMm16w3EdAR5qzKxkWeT3UzirZgkuEurDv7sJrf+ygXLBww6mb6k9d+mYyttYLzZ1cvmtAglQxbMcaxvzCSUwzsU52eA=; X-YMail-OSG: NvblJPQVM1ncDFizpRasS.Tjyu7wVnI0AqgwPQrCB0j7wf. lnq67mZQHjP7vY4ZpLFChdFPdJ0d3BDq2JeItN1ARZhHKNj9z_paaCn2WkNH 4aIf_hULTPRNF_e0cIrYZdXm23hi60BdulUo_dvXRHY2rIDNFNzhJVnWvAAP BhkBpnp1.t379rOisbhwpJHY17qBV3TRJvsAR9iZypNiA5ssPGbAbjCOAZyI yP5GHGyZqvqo.O61I3p2jACWP4VS.ILC__YRp17CGL00_mKQNnmfWERRe07N f9dsiima10YEOT4gYKLQobvWY.khCDLcRZhs_6nTntxMshIkva9YbfOXCetX ZZr_mew2Ib2I4Wl69keS1VzyPleGB0SqcRMe1VW.C4njBcG1JYVVL536.6YM Iimz1QCPHVzKnywklmDSnEY8XyQK0fVzBvh31p.FJwhTs99D5dJSby_JscoN 27liQxhxzrEWyC47.mVF9.fZDLH_SUEa8V6Xm7xi.dsHdQX4QQKYoXA2VWtf EjftaFOh.HfeiX3ikMzdBJHik4BIHLW5LPqEZBlZVRyzo658Zh.ODFcCifhO D4MWqJ7eanZmA1g9Rxczpij1Koq8cxpIWwuxjzKm1nouNgJOFJLNlAcKHSzQ 3h42lE_h8i3_vaKjTWBZ6Pnqd70MZ1B4mIanBT7o1QsA6cWOmWzrXz1Utdmu xRCYRBzEpc4JpI7DxzWADg86SLYJ6YyTuFr5uhtM94CxF1GIkxtqYrSNNRnj ghNQd6en_6_w9pbunkIXSRGCK764FvqJpu0bB8d1wfjB0TtavLL_in98W6my .Q98IuGj3.SAuF4V78xk7z7kn7eteau96MoVb2bR.fSnfxmfW6CFjJ3WCNrP B0r20dgY4e..h5srraUnSIer7rRMUBuVzH784Xz96._ouHOBiuVKwTuZzR.c nXFdkxBs8NiToluZDkZAQd2m9TzS6vspGqLbwk6YC.4xCvLtZCPxXDI4hqua IzyA- Received: from [76.255.18.237] by web162905.mail.bf1.yahoo.com via HTTP; Thu, 05 Sep 2013 08:39:32 PDT X-Rocket-MIMEInfo: 002.001, TSBUYXJrZXNod2FyIFJhbyA8bS50YXJrZXNod2FyLnJhb0Blcmljc3Nvbi5jb20.IHdyb3RlOgoKPiBJIHdhbnQgc3RhcnQgY29udHJpYnV0aW5nIGluIFBvc3RncmVzIGluIGNvZGUgbGV2ZWwuCgpXZWxjb21lIcKgIFlvdSBzaG91bGQgcHJvYmFibHkgc3RhcnQgd2l0aCB0aGlzIHBhZ2UgYW5kIGl0cyBsaW5rczoKCmh0dHA6Ly93aWtpLnBvc3RncmVzcWwub3JnL3dpa2kvRGV2ZWxvcGVyX0ZBUQoKPiBDYW4geW91IHBsZWFzZSBzdWdnZXN0IG1lIHNvbWUgbGlua3Mgd2hlcmUgSSBjYW4gbGVhcm46Cj4gMS4BMAEBAQE- X-Mailer: YahooMailWebService/0.8.156.576 References: <1C16813DAFF3E44B939586605D40E9F011505B10@ESESSMB107.ericsson.se> Message-ID: <1378395572.3466.YahooMailNeo@web162905.mail.bf1.yahoo.com> Date: Thu, 5 Sep 2013 08:39:32 -0700 (PDT) From: Kevin Grittner Reply-To: Kevin Grittner Subject: Re: [PERFORM] Can you please suggest me some links where I can learn: To: M Tarkeshwar Rao , pgsql-general , postgres performance list In-Reply-To: <1C16813DAFF3E44B939586605D40E9F011505B10@ESESSMB107.ericsson.se> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: 0.7 (/) 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 M Tarkeshwar Rao wrote: > I want start contributing in Postgres in code level. Welcome!=A0 You should probably start with this page and its links: http://wiki.postgresql.org/wiki/Developer_FAQ > Can you please suggest me some links where I can learn: > 1.=A0=A0=A0=A0=A0=A0 Transaction Isolation in Database http://www.postgresql.org/docs/current/interactive/transaction-iso.html > 2.=A0=A0=A0=A0=A0=A0 Query procession and possible optimizations. http://www.postgresql.org/docs/current/interactive/overview.html http://www.pgcon.org/2011/schedule/attachments/188_Planner%20talk.pdf http://www.justin.tv/sfpug/b/419326732 > 3.=A0=A0=A0=A0=A0=A0 How to improve query and its performance. http://wiki.postgresql.org/wiki/Performance_Optimization > 4.=A0=A0=A0=A0=A0=A0 MVCC in detail. http://www.slideshare.net/profyclub_ru/mvcc-unmaskedbruce-momjian --=20 Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company --=20 Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general