Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group