Re: [ADMIN] [PERFORM] 2 server with same configuration but huge difference in performance

2017-08-01 Thread Naveen Kumar
Hello Sumeet, Compare schema on both database to make sure there is no mismatches. And verify LOCKs. if all looks good, do analyze on newly created database before start execution. This will help you. New database doesn't have any stats for generate execution plan. Thanks & Regards, Naveen

Re: [PERFORM] 2 server with same configuration but huge difference in performance

2017-08-01 Thread Scott Marlowe
On Tue, Aug 1, 2017 at 8:45 AM, Sumeet Shukla wrote: > It seems that it is happening because of the way the database is created. On > an old database it runs perfectly fine or if I use the old DB as template to > create the new one, it runs fine. But if I create a new

Re: [PERFORM] 2 server with same configuration but huge difference in performance

2017-08-01 Thread Sumeet Shukla
It seems that it is happening because of the way the database is created. On an old database it runs perfectly fine or if I use the old DB as template to create the new one, it runs fine. But if I create a new DB with same settings and permissions it hangs. I'm now trying to find the difference

Re: [PERFORM] 2 server with same configuration but huge difference in performance

2017-08-01 Thread Scott Marlowe
On Tue, Aug 1, 2017 at 6:41 AM, Sumeet Shukla wrote: > Hi, > > I have 2 PG servers with same h/w and configuration and they are not in > replication. > > On server A it takes 20 minutes to execute the script. > On server B it takes more than 20 hours. (Seems to be stuck

Re: [PERFORM] How to access data of SQL server database from PostgreSQL

2017-08-01 Thread Joshua D. Drake
On 07/31/2017 09:25 PM, Daulat Ram wrote: Hi team, I need to connect to MS-SQL server 2008/2012 from PostgreSQL 9.5 in Windows7 environment to fetch the tables of SQL server. Please help on this. https://github.com/tds-fdw/tds_fdw JD Regards, Daulat

Re: [PERFORM] [ADMIN] 2 server with same configuration but huge difference in performance

2017-08-01 Thread Anthony Sotolongo
Hi Sumeet Shukla While script is running check the pg_stat_activity, this view can be util Regards Anthony On 01/08/17 10:16, Keith wrote: On Tue, Aug 1, 2017 at 9:41 AM, Sumeet Shukla > wrote: Hi, I have 2 PG

Re: [PERFORM] [ADMIN] 2 server with same configuration but huge difference in performance

2017-08-01 Thread Keith
On Tue, Aug 1, 2017 at 9:41 AM, Sumeet Shukla wrote: > Hi, > > I have 2 PG servers with same h/w and configuration and they are not in > replication. > > On server A it takes 20 minutes to execute the script. > On server B it takes more than 20 hours. (Seems to be

[PERFORM] 2 server with same configuration but huge difference in performance

2017-08-01 Thread Sumeet Shukla
Hi, I have 2 PG servers with same h/w and configuration and they are not in replication. On server A it takes 20 minutes to execute the script. On server B it takes more than 20 hours. (Seems to be stuck with create index and and create foreign key steps) Any guidance to troubleshoot this would

Re: [PERFORM] How to access data of SQL server database from PostgreSQL

2017-08-01 Thread Anthony Sotolongo
Hi Daulat This is not the list for that (check https://www.postgresql.org/list/), but if you want to access sql server look at tds_fdw( https://github.com/tds-fdw/tds_fdw), I do not know if it installs on windows, I've only used it on linux, and function very well. Regards Anthony On