From: Markus Schaber <schabios@logi-track.com>
To: Ramon Bastiaans <bastiaans@sara.nl>
Cc: pgsql-performance@postgresql.org
Subject: Re: multi billion row tables: possible or insane?
Date: Tue, 01 Mar 2005 15:01:50 +0100
Message-ID: <422475CE.9030507@logi-track.com> (raw)
In-Reply-To: <42243725.6060804@sara.nl>
References: <42243725.6060804@sara.nl>
Hi, Ramon,
Ramon Bastiaans schrieb:
> The database's performance is important. There would be no use in
> storing the data if a query will take ages. Query's should be quite fast
> if possible.
Which kind of query do you want to run?
Queries that involve only a few rows should stay quite fast when you set
up the right indices.
However, queries that involve sequential scans over your table (like
average computation) will take years. Get faaaaaast I/O for this. Or,
better, use a multidimensional data warehouse engine. Those can
precalculate needed aggregate functions and reports. But they need loads
of storage (because of very redundant data storage), and I don't know
any open source or cheap software.
Markus
--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios@logi-track.com | www.logi-track.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: schabios@logi-track.com, bastiaans@sara.nl
Subject: Re: multi billion row tables: possible or insane?
In-Reply-To: <422475CE.9030507@logi-track.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox