Re: Pushing PostgreSQL to the Limit (urgent!) - Mailing list pgsql-general

From Arjen van der Meijden
Subject Re: Pushing PostgreSQL to the Limit (urgent!)
Date
Msg-id agutim$pbh$1@news.tudelft.nl
Whole thread Raw
In response to Pushing PostgreSQL to the Limit (urgent!)  (Exellon <exellon@linuxsolutions.com.br>)
List pgsql-general
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 :)


pgsql-general by date:

Previous
From: Doug Fields
Date:
Subject: Re: PostgreSQL in mission-critical system
Next
From: ktt
Date:
Subject: Re: help (maybe i'm a little stupid)