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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group