Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id CB04E9FB5E8 for ; Tue, 23 Jan 2007 23:21:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 46993-01 for ; Tue, 23 Jan 2007 23:21:25 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from smtp3.clear.net.nz (smtp3.clear.net.nz [203.97.33.64]) by postgresql.org (Postfix) with ESMTP id 72E709FB2DA for ; Tue, 23 Jan 2007 23:21:25 -0400 (AST) Received: from [192.168.1.11] (121-72-69-246.dsl.telstraclear.net [121.72.69.246]) by smtp3.clear.net.nz (CLEAR Net Mail) with ESMTP id <0JCC00HOYRYTHB00@smtp3.clear.net.nz> for pgsql-performance@postgresql.org; Wed, 24 Jan 2007 16:20:55 +1300 (NZDT) Date: Wed, 24 Jan 2007 16:20:47 +1300 From: Mark Kirkwood Subject: Re: extract(field from timestamp) vs date dimension In-reply-to: <20070123133548.GA17420@oppetid.no> To: Tobias Brox Cc: Chad Wagner , pgsql-performance@postgresql.org Message-id: <45B6D08F.5090104@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7bit References: <20070123124937.GA13122@oppetid.no> <81961ff50701230524y14aa883alfe4dab8d1dd5cf10@mail.gmail.com> <20070123133548.GA17420@oppetid.no> User-Agent: Thunderbird 1.5.0.9 (X11/20061227) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/356 X-Sequence-Number: 22957 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