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
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