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

Поиск
Список
Период
Сортировка
От Creager, Robert S
Тема How to avoid large tables - WAS RE: Fast Inserts and H ardware Questions
Дата
Msg-id 10FE17AD5F7ED31188CE002048406DE8514D07@lsv-msg06.stortek.com
обсуждение исходный текст
Ответы Re: How to avoid large tables - WAS RE: Fast Inserts and H ardware Questions
Список 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@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.
>

В списке pgsql-general по дате отправления:

Предыдущее
От: Orion Henry
Дата:
Сообщение: Re: Fast Inserts and Hardware Questions
Следующее
От: Antoine Reid
Дата:
Сообщение: Re: Sluggish INSERTS with Foreign Keys (7.1beta5)