Hi, I have a database with the 2 principal tables using 716,819 rows and 43,157,442 rows each one, related each one, I have some triggers and stored procedures and views having a frontend made in Visual Basic using ODBC and ADO to connect to the database, Im considering to move from Microsoft SQL Server 7.0 to PostgreSQL because this stuff its getting big and getting slower, Im backing up must of things but I would like to know if I can get some improvement changing from Win NT 4.0-MSSQL to Linux-Postgresql.
What do you all think ? Should I change ?