--- Paulo Henrique Baptista de Oliveira
<baptista@linuxsolutions.com.br> wrote:
> 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 have a similar application. I am storing astronomical data
from a set of automated cameras. The data just floods in
forever. I can see a billion rows in the future.
I find that I _can_ keep up using only modest hardware IF I use
"COPY" and not "INSERT" to input the data. "COPY" is much, much
faster. Also indexes help with SELECT speed not really hurt
COPY/INSERT speed so you need to ballance. 1 Million per
24 hour period is not to much for a "standard" PC BUT if you
also want to do many SELECTS or JOINS at the same time then
you will need more so the hardware depends on what _else_ you
are doing.
=====
Chris Albertson
Home: 310-376-1029 chrisalbertson90278@yahoo.com
Cell: 310-990-7550
Office: 310-336-5189 Christopher.J.Albertson@aero.org
__________________________________________________
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com
