REINDEX vs VACUUM

2022-12-31 Thread Hao Zhang
What is the difference between reindex and vacuum's impact on index file? I deleted an indexed row. Running either vacuum or reindex shows the index entry for the row is removed from the index page. I was under the impression that only reindex will remove dangling index entries. I am guessing that

Re: Inserts create new records in reporting table

2022-12-31 Thread Ron
200K *total* records, or 200K records per day/month/quarter/etc?  Because 200K records isn't that much on modern hardware.  Heck, it wasn't much 20 years ago on "Enterprise" hardware. And you don't mention the window for loading the data into "the" table, and then into the reporting table. A