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

Re: PostgreSQL for Data Warehouse

From: Michelle Konzack <linux4michelle(at)tamay-dogan(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: PostgreSQL for Data Warehouse
Date: 2008-10-08 00:59:43
Message-ID: 20081008005943.GC21095@tamay-dogan.net (view raw or flat)
Thread:
Lists: pgsql-novice
Am 2008-10-03 00:28:40, schrieb Jasmin Dizdarevic:
> 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

I have not a warehouse but a WAR database where I had for 100 years  one
table...  The table from the last century had let me re-thinking...

2.5 mio rows with arround 240 columns and 43 languages had killed all.

It was a SINGEL table of arround 800 MByte.


Thanks, Greetings and nice Day/Evening
    Michelle Konzack
    Systemadministrator
    24V Electronic Engineer
    Tamay Dogan Network
    Debian GNU/Linux Consultant


-- 
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack   Apt. 917                  ICQ #328449886
+49/177/9351947    50, rue de Soultz         MSN LinuxMichi
+33/6/61925193     67100 Strasbourg/France   IRC #Debian (irc.icq.com)

In response to

pgsql-novice by date

Next:From: Bastiaan OlijDate: 2008-10-08 01:11:04
Subject: Re: Canceling statement due to user request?
Previous:From: Bastiaan OlijDate: 2008-10-07 22:12:15
Subject: Canceling statement due to user request?

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