New answers tagged

6

Why don't "statistics" options appear in the job's command? Because you updated the default parameter in the procedure call. This means that if you call the procedure without these parameters, E.G. EXECUTE dbo.IndexOptimize @Databases ='USER_DATABASES', @LogToTable='Y' that these default parameters @UpdateStatistics = 'ALL' & @...


2

You can just add the parameters to the job, it will just execute the SQL statement. This is the official documentation, any parameters here you can add to the procedure, it also has some examples. Ola hallengren site For example this is an example that I have running now: EXECUTE dbo.IndexOptimize @Databases = 'USER_DATABASES, @FragmentationLow = NULL, @...


0

You can see the progress of vacuum with select * from pg_stat_progress_vacuum; Here are some tips for vacuuming large tables https://medium.com/coding-blocks/optimizing-storage-and-managing-cleanup-in-postgresql-c2fe56d4cf5 You do not have to wait too long for autovacuuming


Top 50 recent answers are included