Re: Purging few months old data and vacuuming in production

Thank you for the details, experience shared and the suggestions.
Apologies for the delay in collecting the response for the queries.

(1)Are the tables tied together by FK?
  - Overall there are 9 tables (sorry not 6 as mentioned originally) that are being purged. Only 4 tables would be
havingFK relationship.   

(2)How big are the rows?
  - The 9 tables now occupy almost 2TB space. Below is the rowsize (in bytes) and record-count details -

    236    188,055,675
    297    296,941,261
    371    58,673,649
      95    57,477,553
    904    296,743,680
    234    188,161,891
    414    430,411,653
    707    735,895,015
    128    155,104,922

(3)Is there an index on the date field?
  - Yes. But only in one table, which is the main table (records to purge in rest of the tables is based on this
table). 

(4)Can you drop unneeded indices during the window, and then rebuild them afterward?
  - Not sure, if the time window within which the purge process must complete would be sufficient to do drop and
rebuildof indices. 

(5)How beefy is your hardware?
  - No. of cores - 64
    Memory - 128GB
    Disk - SSD, Total capacity - 8.5TB

Thank you...This electronic mail (including any attachment thereto) may be confidential and privileged and is intended
onlyfor the individual or entity named above. Any unauthorized use, printing, copying, disclosure or dissemination of
thiscommunication may be subject to legal restriction or sanction. Accordingly, if you are not the intended recipient,
pleasenotify the sender by replying to this email immediately and delete this email (and any attachment thereto) from
yourcomputer system...Thank You.