topic Re: Performance increase for dedicated Postgresql in Management & Governance

Performance increase for dedicated Postgresql

santhoshthomas — Fri, 15 Nov 2024 21:54:38 GMT

Hi,

As we implemented a dedicated server for our Postgresql, is there a performance drop or increase. We recently changed our servers as part of windows EOSL. Even after our configurations are same we see most of our tasks are taking more than on the previous server. Wondering what could be the reason for this.

Re: Performance increase for dedicated Postgresql

Clever_Anjos — Tue, 11 Apr 2023 16:40:19 GMT

Do you mean the PostgreSQL as the metadata repository or data extraction?

Re: Performance increase for dedicated Postgresql

santhoshthomas — Tue, 11 Apr 2023 16:49:43 GMT

Thanks Clever_Anjos.

PostgreSQL as repository

Re: Performance increase for dedicated Postgresql

Clever_Anjos — Tue, 11 Apr 2023 17:02:34 GMT

This shouldn´t impact that much (considering the PostgreSQL is in the same LAN/VLAN).

"taking more than on the previous server" how much time was added?

Re: Performance increase for dedicated Postgresql

santhoshthomas — Tue, 11 Apr 2023 17:12:08 GMT

	Old_Task Reload Time	New_Task Reload Time
Task 1	00:04:20	00:40:40
Task 2	00:00:18	00:02:53
Task 3	00:02:00	00:03:48
Task 4	00:01:03	00:01:43
Task 5	00:14:09	00:23:38
Task 6	00:07:48	00:09:35
Task 7	00:19:17	00:20:47
Task 8	00:14:06	00:15:37
Task 9	00:06:13	00:08:29
Task 10	00:00:11	00:01:29

Re: Performance increase for dedicated Postgresql

santhoshthomas — Wed, 12 Apr 2023 18:31:22 GMT

Hi,

I would except the above sample reload time is sufficient enough to understand the problem. Please let us know if you need anything more on this. Thanks

Re: Performance increase for dedicated Postgresql

Clever_Anjos — Thu, 13 Apr 2023 01:17:37 GMT

Could you please check the app size for every task?

It´s odd that some tasks are consuming pretty the same time and other are taking much longer

Did you move the shared folder to another machine as well?

Re: Performance increase for dedicated Postgresql

santhoshthomas — Thu, 13 Apr 2023 16:31:45 GMT

	File Size (MB)	Old_Task Reload Time	New_Task Reload Time
Task 1	0.14	00:00:16	00:09:02
Task 2	2.52	00:00:18	00:02:53
Task 3	287.72	00:02:00	00:03:48
Task 4	34.88	00:01:03	00:01:43
Task 5	0.16	00:14:09	00:23:38
Task 6	0.15	00:07:48	00:09:35
Task 7	928.28	00:19:17	00:20:47
Task 8	229.89	00:14:06	00:15:37
Task 9	0.15	00:06:13	00:08:29
Task 10	0.14	00:00:11	00:01:29

We have moved the shared folder also to the new machine.

Re: Performance increase for dedicated Postgresql

Clever_Anjos — Thu, 13 Apr 2023 20:29:17 GMT

Besides tasks #1 and #2 now you are having pretty similar times, right?

Why the old_task reload time is so different your two tables? (today and tuesday)

Re: Performance increase for dedicated Postgresql

santhoshthomas — Fri, 14 Apr 2023 17:14:04 GMT

We have almost 50 tasks which shows a difference in time, so as a sample I just included 10 tasks.

Task #1 was completing it's reload with 16 seconds (QlikView), whereas the new QlikSense has a reload time of 9 minutes, 2 seconds.

Please ignore the difference between tuesday and today, as I have considered different task for the fist task mentioned in the table