Re: Functional dependencies and GROUP BY

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Functional dependencies and GROUP BY
Дата
Msg-id 1277496390.5356.23.camel@vanquo.pezone.net
обсуждение исходный текст
Ответ на Functional dependencies and GROUP BY  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: Functional dependencies and GROUP BY  (Alex Hunsaker <badalex@gmail.com>)
Список pgsql-hackers
On mån, 2010-06-07 at 21:33 +0300, Peter Eisentraut wrote:
> I have developed a patch that partially implements the "functional
> dependency" feature that allows some columns to be omitted from the
> GROUP BY clause if it can be shown that the columns are functionally
> dependent on the columns in the group by clause and therefore
> guaranteed to be unique per group.

Second version:

I stripped out all checks except the primary key/unique constraint
checks.

Views whose existence depends on one of those constraints get a
dependency recorded.  This depends on the patch currently in the commit
fest to record not null constraints in pg_constraint, so that the
dependencies on not-null constraints can be recorded.

I haven't done any caching of index lookups yet.  Some testing with
1600-column tables didn't show any effect.  I'll test this a little
more.


Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Admission Control
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Admission Control