Re: [GENERAL] designing time dimension for star schema

2014-02-15 Thread Mark Wong
On Mon, Feb 10, 2014 at 8:45 AM, Mark Wong wrote: > Hello everybody, > > I was wondering if anyone had any experiences they can share when > designing the time dimension for a star schema and the like. I'm > curious about how well it would work to use a timestamp for the

Re: [GENERAL] designing time dimension for star schema

2014-02-10 Thread Mark Wong
On Mon, Feb 10, 2014 at 9:20 AM, CS DBA wrote: > I've done a lot of DSS architecture. A couple of thoughts: > > - in most cases the ETL process figures out the time id's as part of the > preparation and then does bulk loads into the fact tables > I would be very concerned about performance o

[GENERAL] designing time dimension for star schema

2014-02-10 Thread Mark Wong
Hello everybody, I was wondering if anyone had any experiences they can share when designing the time dimension for a star schema and the like. I'm curious about how well it would work to use a timestamp for the attribute key, as opposed to a surrogate key, and populating the time dimension with

[GENERAL] Fwd: PDXPUG Day at OSCON 2010

2010-05-25 Thread Mark Wong
It was recommended to me to forward this to -general. Regards, Mark -- Forwarded message -- From: Mark Wong Date: Tue, May 18, 2010 at 6:57 AM Subject: PDXPUG Day at OSCON 2010 To: pgsql-annou...@postgresql.org Thanks to the generosity of O'Reilly, we will be having a ful

Re: [GENERAL] [pgsql-advocacy] OLS BOF for linux & postgresql

2005-01-28 Thread Mark Wong
On Fri, Jan 28, 2005 at 09:10:07PM -0500, Robert Bernier wrote: > On January 28, 2005 05:06 pm, Mark Wong wrote: > > I wanted to bounce the idea of a BOF at the Linux Symposium in > > Ottawa and see if anyone would like to attend. The deadline to > > proposal is Feb 1st,

[GENERAL] OLS BOF for linux & postgresql

2005-01-28 Thread Mark Wong
I'm told these lists were more appropriate for this kind of announcement than hackers, so here it is. - Forwarded message from Mark Wong <[EMAIL PROTECTED]> - Date: Tue, 25 Jan 2005 16:59:16 -0800 To: pgsql-hackers@postgresql.org From: Mark Wong <[EMAIL PROTECTED]> Subje

Re: [GENERAL] [HACKERS] OSDL DBT-2 for PostgreSQL

2003-08-01 Thread Mark Wong
On Fri, Aug 01, 2003 at 05:05:18PM -0700, Josh Berkus wrote: > Mark, > > > I've just got our DBT-2 workload (TPC-C derivate) working with > > PostgreSQL using C stored functions and libpq. I'd love to get some > > feedback. > > I'm confused. Jenny Zhang just announced OSDL-DBT3 for Postgres; i