10 TB database - Mailing list pgsql-general

Hi!

We are thinking to create some stocks related search engine.
It is experimental project just for fun.

The problem is that we expect to have more than 250 GB of data every month.
This data would be in two tables. About 50.000.000 new rows every month.

We want to have access to all the date mostly for generating user
requesting reports (aggregating).
We would have about 10TB of data in three years.

Do you think is it possible to build this with postgresql and have any
idea how to start? :)


Thanks in advance,
Artur




pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: running pg_dump from python
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: 10 TB database