How to avoid large tables - WAS RE: Fast Inserts and H ardware Questions

Alex (or any one else),

How would you suggest avoiding large tables?  I attempting to develop an
application which might see as much as 6M records inserted a day during peak
times.  Thankfully, this is a volunteer effort, so no real pressure for me
to solve this problem quickly.

Later,
Rob

Robert Creager
Senior Software Engineer
Client Server Library
303.673.2365 V
303.661.5379 F
888.912.4458 P
StorageTek
INFORMATION made POWERFUL



> -----Original Message-----
> From: adb [mailto:adb@Beast.COM]
> Sent: Wednesday, March 14, 2001 5:15 PM
> To: Orion Henry
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Fast Inserts and Hardware Questions
> 
> 
> What I would be most concered about is a table that grows by 
> a few million 
> rows a week, that to me seems like a liability in itself since
> maintenance on that table will get pretty slow after a few months.
> 
> Alex.
>