3 ms·

I don't delete anything in those tables, however I do one update on 9/10 of the rows, at least. I seem to remember there was a way to reorder rows in a table,

by aspyct 4y ago

I don't delete anything in those tables, however I do one update on 9/10 of the rows, at least. I seem to remember there was a way to reorder rows in a table, maybe that could be useful.

pramsey 4y ago
You can check if your data remain correlated after your updates. It's possible they do: SELECT correlation FROM pg_stats WHERE tablename = 'mytable' AND attname = 'mytimestamp';
- aspyct 4y ago
  Oh nice! I had no idea, I'll try it, thanks :)