|
We have 2 tables we expect to grow by up to
50,000 rows per day each depending on the customer. In normal
operation we will most likely never update or delete from these tables
as they are for historical reporting. (Eventually we may but a limit
on the amount of data and delete older than X months or such)
We intend to create a number of indexes based
upon the reporting search criteria. What would the best setup be for VACUUM, ANALYSE,
REINDEX. Alot of the infor refers to data hanging around from deletes and
updates which in normal course we will not do on these tables?
Oisin
|
