Re: extract(field from timestamp) vs date dimension

From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
To: Tobias Brox <tobias(at)nordicbet(dot)com>
Cc: Chad Wagner <chad(dot)wagner(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: extract(field from timestamp) vs date dimension
Date: 2007-01-24 03:20:47
Message-ID: 45B6D08F.5090104@paradise.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Galy Lee 2007-01-24 05:37:44 how to plan for vacuum?
Previous Message Mark Kirkwood 2007-01-24 00:51:51 Re: slow result