Re: [HACKERS] VIEWS, DISTINCT and COUNT

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Jan Wieck <wieck(at)debis(dot)com>, bhirt(at)mobygames(dot)com, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] VIEWS, DISTINCT and COUNT
Date: 1999-11-04 05:16:23
Message-ID: 199911040516.AAA16503@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Not necessarily --- the aggregate and group nodes must be there, but
> we don't want to commit to seqscan&sort vs. indexscan sooner than we
> have to. I think what's needed here is some notion of an abstract
> plan tree. The trick is to pick the right level of abstraction.
> Maybe "Aggregate -> Group -> OrderedTupleSource" is the way to think
> about it.
>
> But your end point is valid: we want to be able to make a structure
> like that be an input to a higher-level plan tree. This is also
> necessary for subselect in FROM clause, isn't it?
>
> > Again, who knows enough about the planner to be able to do
> > this kind of stuff?
>
> I could take it on, but I have a lot of other stuff I want to do for
> 7.0. Is this more important than fixing fmgr or improving the
> planner's selectivity estimates? I dunno...

Let me make a comment. Seems like a whole host of problems will be
fixed by this overhaul, but none of the problems is major.

Jan's foreign key support, Vadim's WAL, and Tom Lane's cleanups are of
major importance for 7.0, so it seems we better focus on those, and if
we have time before 7.0, and all people involved have time, we can take
on that work. We will need to have most of us available to discuss and
merge the changes into all the affected areas.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message nicks.emails 1999-11-04 05:36:22 your commnts
Previous Message Tom Lane 1999-11-04 04:41:07 Re: [HACKERS] VIEWS, DISTINCT and COUNT