Re: Dreaming About Redesigning SQL - Mailing list pgsql-hackers

From Marshall Spight
Subject Re: Dreaming About Redesigning SQL
Date
Msg-id mhMlb.2417$9E1.18525@attbi_s52
Whole thread Raw
In response to Re: Dreaming About Redesigning SQL  (Christopher Browne <cbbrowne@acm.org>)
List pgsql-hackers
"Bob Badour" <bbadour@golden.net> wrote in message news:W46dnf4tbfF1DwiiU-KYgw@golden.net...
>
> All physical structures will bias performance for some operations and
> against others.

This strikes me as a succinct statement of the value of
data independence. One has the option (but not the
requirement) to adjust the physical structures the DBMS
uses while keeping the logical model (and therefor all
application code and queries, etc.) unchanged.

Unless one has data independence, one does not have
this option; one will be locked into a particular
performance model. This is why I found the MV
guy's obvious pleasure at being able to precisely
describe the performance model for his DB as odd:
I thought it a deficit to be able to say what it was;
he thought it an asset.


Marshall

PS. This is nothing you don't know, Bob; just a
comment for the group.




pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: pg_ctl reports succes when start fails
Next
From: "Bob Badour"
Date:
Subject: Re: Dreaming About Redesigning SQL