Is it safe (performance, locking, etc) to update fields in a monthly partitioned table?
Hello. We have a table which as of this writing has like 4.6 billion records. I'm a software engineer and am working on a project which will involve releasing a job that will update a field in this table for existing records. The data in this table started on 2015-07-01, thus, as of this writing it spans like 2 years up to date. This table gets filled by a single job with real time data every 2 minutes. The job that I'm working on will update records that are at least 1 day old. There are many jobs which read data from this table. Question: is it safe to release the updating job? I'm worried about when the updating job will be running could it block or make significantly slower the reading jobs and/or the single writing job.