Re: Pushing PostgreSQL to the Limit (urgent!)

Exellon wrote:
> I have an app that uses a database with 60 tables and a mean of 5 fields in each table.
What kind of fields?
Are it all text fields, or just short varchar/integer fields etc?

> I will put it to insert 30 M (millions) registers by month (or 1 Million by day) in a year is about 400 Millions registers.
> Can pgsql support this? In What Machine?
I don't know why not.
Ofcoarse you have to build your indices and as long as you don't do
weird stuff on your DB (don't try things like "textfield LIKE
'%blabla%'") it should work fine.

The kind of machine you need depends heavily on the type of data and
applications.
The basic rule for DB-machines are always the same though 'have enough
fast storage', 'have enough RAM', 'have enough CPU' (in that order).
A dual P4 Xeon/P3 with 4GB or more memory equiped with a pretty
raidcontroller having a lot of 10k rpm/15k rpm disks attached will do
fine for a lot of applications.

So if you want more specific answers, you'll have to be a bit more
specific to, otherwise noone can advise you more than just the basic
rules :)