Re: PostgreSQL for Data Warehouse

Hi Mark,

thank you for your information. That sound's great!
May I know your hardware configuration on which this database is running?

Jasmin

On Wed, Oct 8, 2008 at 11:21 PM, Mark Roberts <mailing_lists(at)pandapocket(dot)com
> wrote:

> Hmm,
>
> I'm seeing about 20M facts/day input into the system I work on (and
> we've been going for a few years now) and our average response time is
> pretty snappy (<15s for the most common use cases).
>
> IIRC, the online part of the database is ~2.5-3TB right now.
>
> -Mark
>
> On Fri, 2008-10-03 at 00:28 +0200, Jasmin Dizdarevic wrote:
> > Hi,
> >
> > i'm actually evaluating different dbms for data warehouse tasks.
> > has anybody expirience with it?
> >
> > i have to store 50 mio. records p.m. in a fact table.
> > something like this:
> >
> > date; cust; group; product; value
> >
> > ...with unique index on date,cust,group,product.
> >
> > will there be any problem's in response time in let's say 12 months?
> >
> > thank you very much.
> >
>
>

--
Mit freundlichen Grüßen

Dizdarevic Jasmin
Sonnenbergstr. 3
6714 Nüziders, AUT

jasmin(dot)dizdarevic(at)gmail(dot)com
+43 664 411 79 29