Re: Forcasting in Postgresql

This is great, thank you so much!

On Thu, 2 Mar, 2023, 11:17 pm , <dave(at)davebolt(dot)co(dot)uk> wrote:

> The short, unhelpful, answer is Yes.
>
>
>
> Time to take a step back from the SQL and ask yourself:
>
> Can I write an algorithm to forecast some value dependant on values I
> already have.
>
>
>
> Very simple, somewhat vague, example.
>
> I have been selling Snow Tyres for some time so I have values for sales
> along with dates.
>
> What are the average sales for each month?
>
> If I have more than one year’s data, what are the averages per month over
> the last X years?
>
> Is a running average over the last few weeks/months/year any use?
>
> Some made up figures.
>
> Given that my average sales (in the Northern Hemisphere), were 20 in
> November, 18 in December, 2 in January, 3 in February, I might expect
> significant sales in November and December, but a drop in sales in January
> and February.
>
> If last year the actual figures for November to February were 2,30,0,3,
> and the previous year were 38,6,4,3 then there is still a drop in sales in
> January and February, and still high sales in November and December, it’s
> just a little more complicated.
>
> (If I were selling Snow Tyres, I would possibly look at these figures and
> get some stock in for November so that I would have stock on hand for the
> rest of the year, but now we are getting on to questions relating to order
> lead times).
>
>
>
> I noticed that what I had intended to be a simple example quickly started
> to become more complicated.
>
> I needed a clear definition of what I had, and what I wanted, so I tried
> to draw on my experience using a Stock Control System in the ‘80s and make
> up some easy data. I know that real systems that attempt to predict
> ordering quantities can soon get deep into Statistics, which is not one of
> my strengths. For this particular example I would be looking at search
> results for ‘stock management algorithm’ as a starting point.
>
>
>
> Hope this helps a little.
>
> Regards
>
> Dave Bolt
>
>
>
> *From:* Govardhan .G [mailto:govardhansrr(at)gmail(dot)com]
> *Sent:* 01 March 2023 07:48
> *To:* pgsql-admin(at)lists(dot)postgresql(dot)org
> *Subject:* Forcasting in Postgresql
>
>
>
> Hi Folks,
>
> Is it possible to write a query for forecasting in postgresql. I have been
> trying to search but have no clue. please advise
>
> Thanks
>