Re: [GENERAL] Including unique users in huge data warehouse in Postgresql...

2006-11-29 Thread Mark Jensen
iginal Message From: Richard Huxton To: Mark Jensen <[EMAIL PROTECTED]> Cc: pgsql-general@postgresql.org Sent: Wednesday, November 29, 2006 2:29:35 PM Subject: Re: [GENERAL] Including unique users in huge data warehouse in Postgresql... Mark Jensen wrote: > So i've been given t

Re: [GENERAL] Including unique users in huge data warehouse in Postgresql...

2006-11-29 Thread Richard Huxton
Mark Jensen wrote: So i've been given the task of designing a data warehouse in either Postgresql or Mysql for our clickstream data for our sites. I started with Mysql but the joins in Mysql are just way too slow compared to Postgresql when playing with star schemas. Mark - it's not my usual a