Re: extract(field from timestamp) vs date dimension - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: extract(field from timestamp) vs date dimension
Date
Msg-id 45B6D08F.5090104@paradise.net.nz
Whole thread Raw
In response to Re: extract(field from timestamp) vs date dimension  (Tobias Brox <tobias@nordicbet.com>)
List 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 by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: slow result
Next
From: Galy Lee
Date:
Subject: how to plan for vacuum?