From: Scott Marlowe <scott.marlowe@gmail.com>
To: Campbell, Lance <lance@uiuc.edu>
Cc: pgsql-performance@postgresql.org
Subject: Re: Terminology Question
Date: Mon, 20 Aug 2007 09:50:18 -0500
Message-ID: <dcc563d10708200750g593cd883v60b71e045e1c91a8@mail.gmail.com> (raw)
In-Reply-To: <B10E6810AC2A2F4EA7550D072CDE8760197D1A@SAB-FENWICK.sab.uiuc.edu>
References: <B10E6810AC2A2F4EA7550D072CDE8760197D1A@SAB-FENWICK.sab.uiuc.edu>
On 8/20/07, Campbell, Lance <lance@uiuc.edu> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: scott.marlowe@gmail.com, lance@uiuc.edu
Subject: Re: Terminology Question
In-Reply-To: <dcc563d10708200750g593cd883v60b71e045e1c91a8@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox