Re: extract(field from timestamp) vs date dimension

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: extract(field from timestamp) vs date dimension
Дата
Msg-id 45B6D08F.5090104@paradise.net.nz
обсуждение исходный текст
Ответ на Re: extract(field from timestamp) vs date dimension  (Tobias Brox <tobias@nordicbet.com>)
Список pgsql-performance
Tobias Brox wrote:

>
> I suppose the strongest argument for introducing date dimensions already
> now is that I probably will benefit from having conform and
> well-designed dimensions when I will be introducing more data marts.  As
> for now I have only one fact table and some few dimensions in the
> system.
>

Another factors to consider is that end user tools (and end users) may
find a date/time dimension helpful.

Best wishes

Mark

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

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: slow result
Следующее
От: Galy Lee
Дата:
Сообщение: how to plan for vacuum?