Skip to main content
4 votes

Iterate between dates and INSERT values in a performant way

Instead of a loop which inserts one row after the other you should use generate_series to create all timestamps at once. Untested: ...
dnoeth's user avatar
  • 1,172
1 vote

Univariate analysis with SQL stored procedure

My comments is limited because I know next to nothing about statistics and I admit I don't understand what most of the calculations are supposed to do or how to interpret the results. That said, you ...
this's user avatar
  • 2,029

Only top scored, non community-wiki answers of a minimum length are eligible