Hi Everybody, I have a table that I add rows every evening. A rule I have for this table is that no row ever gets deleted. It has 600+ million rows.
The last time I did it, it took nearly 4 hours to vacuum and 13 hours 40 minutes to reindex. My rudimental understanding of vacuuming is that when the rows get "deleted" it is only marked as "deleted" but the data is left alone until the act of vacuuming takes place. The vacuuming really gets rid of rows and pushes the data in such the way there is no "hole." And therefore after vacuuming, it is necessary to reindex (and analyze) the table. Is this a correct understanding? If it is (and as new rows get added new indexes are also built for the new rows), the fact that there is no deletion means there is no necessity for vacuuming this particular table? I appreciate any thoughts on this matter. Regards, Tena Sakai tsa...@gallo.ucsf.edu
