As part of an upgrade I decided to REINDEX my database using
REINDEX (VERBOSE, CONCURRENTLY) DATABASE <databasename>.
The log shows:
INFO: index "datastore.ds_sgmt_vg_partner_por_idx_a" was reindexed INFO: index "datastore.ds_sgmt_vg_partner_por_idx_sc" was reindexed INFO: index "pg_toast.pg_toast_2418155_index" was reindexed INFO: table "datastore.ds_sgmt_vg_partner_portal_users" was reindexed DETAIL: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.01 s.
I expected line 1,2 & 4, but was a bit surpised by line 3. I'll have to admit that I do not exactly know what
pg_toast does (or where the name comes from).
Is it a good thing that these indexes are rebuilt too?
Is it a lucky good thing that I decided to try
REINDEX DATABASE in stead of REINDEXING each individual INDEX?