From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | Jeff Davis <pgsql(at)j-davis(dot)com> |
Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Rob Napier <rob(at)doitonce(dot)net(dot)au>, PostgreSQL Advocacy <pgsql-advocacy(at)postgresql(dot)org> |
Subject: | Re: Time to start drafting the 8.4 release |
Date: | 2009-03-31 21:20:45 |
Message-ID: | 20090331212045.GJ11761@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy |
On Tue, Mar 31, 2009 at 02:03:41PM -0700, Jeff Davis wrote:
> On Tue, 2009-03-31 at 11:56 -0700, David Fetter wrote:
> > On Tue, Mar 31, 2009 at 02:10:13PM -0400, Alvaro Herrera wrote:
> > > Jeff Davis wrote:
> > >
> > > > WITH RECURSIVE and window functions could both fall into an
> > > > "analytics" theme of some kind. That doesn't tell the whole
> > > > story, though.
> > > >
> > > > Some of the other major features, like the Visibility Map, are
> > > > very important, but I can't think of any way to make them
> > > > sound exciting (other than a "performance" theme, which is not
> > > > exciting without numbers).
> > >
> > > VM can also be categorized as "analytics", because it makes
> > > vacuuming huge tables so much convenient.
> >
> > Is, "analytics" the latest in the DSS/OLAP/BI series of wacky
> > terms for, "system need not respond within a second?"
>
> WITH RECURSIVE and window functions both increase the expressiveness
> of PostgreSQL's dialect of SQL substantially, allowing users to ask
> interesting questions in a single query that would have been
> impossible to ask before.
Indeed. I've been going around and boring people with this fact for
months :)
> These queries work on small data sets as well, so I don't think that
> these features are only useful for long-running queries.
>
> Do you have a word in mind that captures this benefit better than
> "analytics"? "Expressiveness" might work, but I don't think that
> people really associate that word with database systems.
Maybe that's the hook, then :) POSTGRES, and INGRES before it, were
both from the "active database" camp, and we've taken it much further
with the PL zoo of languages to make PostgreSQL a highly capable
programming environment.
Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2009-03-31 21:38:21 | Re: Time to start drafting the 8.4 release |
Previous Message | Jeff Davis | 2009-03-31 21:03:41 | Re: Time to start drafting the 8.4 release |