| From: | "Creager, Robert S" <CreagRS(at)LOUISVILLE(dot)STORTEK(dot)COM> |
|---|---|
| To: | "'adb'" <adb(at)Beast(dot)COM> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | How to avoid large tables - WAS RE: Fast Inserts and H ardware Questions |
| Date: | 2001-03-15 01:06:43 |
| Message-ID: | 10FE17AD5F7ED31188CE002048406DE8514D07@lsv-msg06.stortek.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)Beast(dot)COM]
> Sent: Wednesday, March 14, 2001 5:15 PM
> To: Orion Henry
> Cc: pgsql-general(at)postgresql(dot)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.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Wolfe | 2001-03-15 01:21:09 | Re: Re: Fast Inserts and Hardware Questions |
| Previous Message | Gordon A. Runkle | 2001-03-15 00:56:35 | Re: Fast Inserts and Hardware Questions |