Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL for Data Warehouse

From: "Jasmin Dizdarevic" <jasmin(dot)dizdarevic(at)gmail(dot)com>
To: "Mark Roberts" <mailing_lists(at)pandapocket(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: PostgreSQL for Data Warehouse
Date: 2008-10-08 21:29:18
Message-ID: a0eee4d40810081429p678cac8p923c9c823c736880@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

Responses

pgsql-novice by date

Next:From: Mark RobertsDate: 2008-10-08 21:47:07
Subject: Re: PostgreSQL for Data Warehouse
Previous:From: Mark RobertsDate: 2008-10-08 21:21:02
Subject: Re: PostgreSQL for Data Warehouse

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group