Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 664179F95DB for ; Mon, 20 Aug 2007 11:50:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 76937-03 for ; Mon, 20 Aug 2007 11:50:20 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.189]) by postgresql.org (Postfix) with ESMTP id 3F2349F95CF for ; Mon, 20 Aug 2007 11:50:20 -0300 (ADT) Received: by rv-out-0910.google.com with SMTP id l15so945275rvb for ; Mon, 20 Aug 2007 07:50:18 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=V7sDp5wInPWrXno5XxqEEt7bXt0IgwAInlBDvjvkbYm0x42RjYtHC/K4jMLAtCxtPPfPWTsocs10gHoMAomJUpQdIvcEJ676n1oIlvg1KYQs+ZMxOfeATuPBcol36RJiATadgS6Q6ocuJz23abfQvI+g3SHIMD8lZEH6e0ZI7fw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=EjoZWl2vjDMtwXaeQTTZkye6T4j9hZ9FIDkMoQ0p239/prtbIEpjvUVUWZQdcXLkBL2SjMhR/oS5Da4Uy2Y0m/pVEU6qXqfEwR8M7SNSXk5+QA5UPDK1g7gMcTUVn8Oz8YcCH2CyCWNAKwYq/rSYFBUJU0Bu3Z+DJJt0odWXXGw= Received: by 10.140.191.14 with SMTP id o14mr2749733rvf.1187621418474; Mon, 20 Aug 2007 07:50:18 -0700 (PDT) Received: by 10.141.98.12 with HTTP; Mon, 20 Aug 2007 07:50:18 -0700 (PDT) Message-ID: Date: Mon, 20 Aug 2007 09:50:18 -0500 From: "Scott Marlowe" To: "Campbell, Lance" Subject: Re: Terminology Question Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/210 X-Sequence-Number: 26340 On 8/20/07, Campbell, Lance wrote: > > Terminology Question: > > If I use the following statement: > > I am backing up schema XYZ every 30 minutes. > > Does this statement imply that I am only backing up the definition of the > data? Or does it mean that I am backing up the definition of the data and > the data within the schema object? In db parlance, schema means two different things really. One is that layout of your data (how tables are related etc...) The other is the namespace that a set of objects can live in. i.e. There is a certain amount of overlap here as well. dbname.schemaname.objectname.fieldname In this instance, "backing up" a schema pretty much implies the namespace version of schema. OTOH, a phrase like "I think your schema has some design flaws pretty obviously points to the first definition relating to the layout of your data.