Analyze chunks after compression

timescale / promscale_extension

[DEPRECATED] Tables, types and functions supporting Promscale

Other

37 stars 17 forks source link

Closed jgpruitt closed 1 year ago

jgpruitt commented 1 year ago

We need to analyze chunks right after we compress them. If we don't, n_live_tup will be zero, and the autovacuum engine will ignore the chunk.

Please take into account the following non-code changes that you may need to make with your PR:

jgpruitt commented 1 year ago

Upon further investigation, I don't think this will actually fix the issue we are trying to fix. AFAICT:

if the stats are missing, the table won’t be vacuumed until we get into anti-wraparound territory
if the stats are missing, running analyze won’t help unless there is subsequent DML to trigger a vacuum