Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 085F0B5DBD0 for ; Fri, 7 Oct 2011 10:39:42 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 82340-09 for ; Fri, 7 Oct 2011 13:39:35 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from mail-yw0-f46.google.com (mail-yw0-f46.google.com [209.85.213.46]) by mail.postgresql.org (Postfix) with ESMTP id E9AF4B5DBC7 for ; Fri, 7 Oct 2011 10:39:33 -0300 (ADT) Received: by ywb5 with SMTP id 5so3619711ywb.19 for ; Fri, 07 Oct 2011 06:39:33 -0700 (PDT) Received: by 10.236.129.228 with SMTP id h64mr9858843yhi.101.1317994773681; Fri, 07 Oct 2011 06:39:33 -0700 (PDT) Received: from ayaki.localdomain ([119.11.11.201]) by mx.google.com with ESMTPS id w50sm12884160yhi.2.2011.10.07.06.39.29 (version=SSLv3 cipher=OTHER); Fri, 07 Oct 2011 06:39:33 -0700 (PDT) Message-ID: <4E8F010E.70704@ringerc.id.au> Date: Fri, 07 Oct 2011 21:39:26 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:6.0.2) Gecko/20110906 Thunderbird/6.0.2 MIME-Version: 1.0 To: Karuna Karpe CC: pgsql-admin@postgresql.org Subject: Re: Some Postgresql Concepts References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201110/25 X-Sequence-Number: 38477 On 10/07/2011 02:12 PM, Karuna Karpe wrote: > 1. Flashback fundamental Flashback? I think you might be confusing this: http://oracle.com/ with this: http://postgresql.org/ > 2. Compression, encryption and decryption Check out TOAST and pgcrypto in the *MANUAL*. http://lmgtfy.com/?q=postgresql+manual (The above too grumpy? Google is a key skill as a DBA, and asking people to do your basic research for you for free and hand the answers to you on a platter is a bit much.) > 3. DB Link and Heterogeneous Concept "Hetrogenous Concept"? dblink is, again, something best learned about using the documentation and Google. > 4. Storage Management Details? What do you want to know? "Storage management" is kind of a broad category. You probably want to read the manual first, then look into things like tablespaces, TOAST, vacuum and autovacuum, etc. -- Craig Ringer