cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

PostgresSQL Database to be Supported for Windchill

PostgresSQL Database to be Supported for Windchill

Here are some advantages over SQL Server:

PostgresSQL is a mature database product and used all over the world.   Instead of spending money on Oracle or SQL Server, invest the money back into PLM, IT infrastructure or additional resource to support the PLM solution.

It's been over 3 years of using, implementing and supporting SQL Server with Windchill 9.1 and 10.1 with PTC Technical Support.  It's just been a horrible experience supporting this.  It was an easy way to convince the executives to move from Oracle to SQL Server but it really kills the maintainability, performance, scalability and support which should be the backbone of implementing any database.

I even attended some SQL Server DB courses and explained to the other SQL Server DB admins who handle some databases both Oracle and SQL Server my environment of over 3 million records.  They all told me, why did you go to SQL Server.  I should have stayed with Oracle.  Everyone in the class including the SQL Server Trainer, who has been teaching and support SQL Server since it's birth, advised me that I shouldn't migrate for large databases 2 million+ records and large amounts of columns in a table because it can be over 8K especially with multi-byte characters (different languages).

Don't listen to all the sales flyers and propaganda, the true experienced experts warned me about SQL Server.

Just like Linux supported by RedHat, Linux has now become the most stable, cost-effective OS server platform.  I hate rebooting my servers 1/week because it just adds headaches and overhead to suppport.  (i.e. Windows OS with Windchill).

Regards,

Patrick

3 Comments
PTCModerator
Emeritus
Status changed to: Acknowledged
 
PatrickChin
5-Regular Member

Hi All,

 

Windows MS SQL Server is much more expensive licensing and not designed to handle large data sets where tables are limited a maximum of 8,060 bytes per row.  So large strings in any value is not possible in MS SQL Server.  Also, windows has the dreaded NUMA issues for memory for multi-processors especially in VMs.  How many of you had your SAN have corrupted data loss because of a Windows NTFS, FAT32 or FAT16 format?

 

This is not the case in Linux systems.  I'm very happy that Windchill PDMLink 12.0.1.1 or future version will be supported with PostgreSQL.  RedHat Linux is very stable and also provides PostgreSQL.  I would like to have PostgreSQL to handle the same NVARCHAR sizing as Oracle multi-byte configuration to default OOTB support of large character size (3X larger in Oracle) and local languages.  So instead of the standard NVARCHAR to be 200, all the respected db scripts should have 600 size in $WT_HOME\db\postgreSQL like in the $WT_HOME/db/sql3 for Oracle in multi-byte. 

 

With all that money saved in licenses, hardware and software, customers can purchase more OOTB software of Windchill for a better PLM solution than customizations.

ttahvanainen
3-Visitor

Hello All,

 

If we add cloud support to the postgres, we could get the CS329263, which would be most welcome of things in this age and world. So, a request for the moderator: please include that article in the voting.