Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
derach2000
Starting Member
37 Posts |
 Posted - 2012-08-16 : 08:39:40
|
| Hi,On one of our current projects, we were practicaly forced by our client to transfer from MSSQL to POSTGRES.After working for sometime on the migration, some questions poped up.Naimly, why isn't postgres the only db in the world since it's free and where ever I turn, poeple are saying that it's the best db in the world. Could someone shed some light on this problem.Kind regardsp.s. Our current problem, simple select * from table, is 4 times slower on postgres ;-) and we cant figure whyArmin Mahmutovicstudent of Clarion,C#,Crystal and SQL martial arts |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-08-16 : 09:03:48
|
| There are other free databases too.Main reason is the functionality and performance provided by other DBMS and their integrated components.No free but you could ask a similar question about mysql.For your current problem you should look at the disk access - is there any and is it that which is causing the issue. MSSQL is built to take advantage of short cuts as it only has to deal with a single O/S and is built by the same company. 4 times is a bit much though - I would suspect there is some issue with the overhead before the query is executed. If the data is already in memory how quick is it?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-08-16 : 09:49:26
|
| This is a wiki comparing MySQL (not MSSQL) to Postgres: http://www.wikivs.com/wiki/MySQL_vs_PostgreSQLThere are descriptions of each product's strengths and weaknesses. If you are using Postgres 8.x or earlier, see if they can upgrade to a 9.x version. There are also links describing workarounds for various problems.Regarding free/open source relational databases, Postgres has the best reputation and feature set if you're comparing it to SQL Server. They have been focusing on improving performance in the 9.x versions, so if you can upgrade you should. |
|
|
|
|
|
|
|
|
MSSQL v POSTGRESQL