Performance increase for dedicated Postgresql

[santhoshthomas]

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.

[Clever_Anjos]

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

[santhoshthomas]

Thanks Clever_Anjos.

PostgreSQL as repository

[Clever_Anjos]

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? 

[santhoshthomas]

	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

[santhoshthomas]

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

[Clever_Anjos]

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?

[santhoshthomas]

	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. 

[Clever_Anjos]

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)

[santhoshthomas]

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