pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedForcasting in Postgresql
5+ messages / 3 participants
[nested] [flat]
* Forcasting in Postgresql
@ 2023-03-01 07:48 Govardhan .G <govardhansrr@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Govardhan .G @ 2023-03-01 07:48 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Forcasting in Postgresql
@ 2023-03-01 16:57 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Govardhan .G <govardhansrr@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: Laurenz Albe @ 2023-03-01 16:57 UTC (permalink / raw)
To: Govardhan .G <govardhansrr@gmail.com>; pgsql-admin@lists.postgresql.org
On Wed, 2023-03-01 at 13:18 +0530, Govardhan .G wrote:
> Is it possible to write a query for forecasting in postgresql.
> I have been trying to search but have no clue. please advise
test=> SELECT 'I don''t think that you will get a good answer to such a generic question';
?column?
══════════════════════════════════════════════════════════════════════════
I don't think that you will get a good answer to such a generic question
(1 row)
Sorry, I couldn't resist.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Forcasting in Postgresql
@ 2023-03-02 16:25 Govardhan .G <govardhansrr@gmail.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 0 replies; 5+ messages in thread
From: Govardhan .G @ 2023-03-02 16:25 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: pgsql-admin@lists.postgresql.org
I don't think so.
There are some iterative patterns in the data then we can forecast the data
in SQL. In some cases it is possible for particular type of data
Thank you
On Wed, Mar 1, 2023 at 10:27 PM Laurenz Albe <laurenz.albe@cybertec.at>
wrote:
> On Wed, 2023-03-01 at 13:18 +0530, Govardhan .G wrote:
> > Is it possible to write a query for forecasting in postgresql.
> > I have been trying to search but have no clue. please advise
>
> test=> SELECT 'I don''t think that you will get a good answer to such a
> generic question';
> ?column?
> ══════════════════════════════════════════════════════════════════════════
> I don't think that you will get a good answer to such a generic question
> (1 row)
>
> Sorry, I couldn't resist.
>
> Yours,
> Laurenz Albe
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* RE: Forcasting in Postgresql
@ 2023-03-02 17:47 dave@davebolt.co.uk
parent: Govardhan .G <govardhansrr@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: dave@davebolt.co.uk @ 2023-03-02 17:47 UTC (permalink / raw)
To: 'Govardhan .G' <govardhansrr@gmail.com>; pgsql-admin@lists.postgresql.org
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@gmail.com]
Sent: 01 March 2023 07:48
To: pgsql-admin@lists.postgresql.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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Forcasting in Postgresql
@ 2023-03-02 17:51 Govardhan .G <govardhansrr@gmail.com>
parent: dave@davebolt.co.uk
0 siblings, 0 replies; 5+ messages in thread
From: Govardhan .G @ 2023-03-02 17:51 UTC (permalink / raw)
To: dave@davebolt.co.uk; +Cc: pgsql-admin@lists.postgresql.org
This is great, thank you so much!
On Thu, 2 Mar, 2023, 11:17 pm , <dave@davebolt.co.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@gmail.com]
> *Sent:* 01 March 2023 07:48
> *To:* pgsql-admin@lists.postgresql.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
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2023-03-02 17:51 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-03-01 07:48 Forcasting in Postgresql Govardhan .G <govardhansrr@gmail.com>
2023-03-01 16:57 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-03-02 16:25 ` Govardhan .G <govardhansrr@gmail.com>
2023-03-02 17:47 ` dave@davebolt.co.uk
2023-03-02 17:51 ` Govardhan .G <govardhansrr@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox