If you really are just inserting, and never updating or deleting, then you will never need to vacuum the table, rather you will just need to ANALYSE the table. If you use autovacuum that is exactly what it will do. As for Reindex, I'm not entirely sure, I don't think you would benefit from reindex because you aren't updating or deleting. Can anyone comment on this? Is is possibile that a table with lots of inserts resulting in lots of page splits etc could ever benifit form REINDEX? Matt > 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 >
