New answers tagged maintenance
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
