[GENERAL] Benchmarking PGSQL against Microsoft SQL 7.0?

1999-01-08 Thread Bryan Field-Elliot

Please forgive my newbieness but I am extremely new to both Postgresql AND
Linux. I've been a consultant for 6 years working mostly on Microsoft
platforms (NT, MSSQL). I have developed many data-driven websites using
WinNT/IIS/ASP/MSSQL. Now, getting sick of MS and being enamored with the
whole Open Source movement, I wish to learn (and develop a project or two)
on Linux/Apache/PHP/PGSQL.

I was wondering if anyone has done any benchmarking (even roughly),
comparing PGSQL to Microsoft SQL Server 7.0 or even the older MSSQL 6.5.
Specifically I just want the reassurance that the two products are in the
same ballpark as far as performance goes. Has anyone done this recently?

Thank you,
Bryan




RE: [GENERAL] Benchmarking PGSQL against Microsoft SQL 7.0?

1999-01-08 Thread Jackson, DeJuan

There has been a discussion in the HACKERS list (check the archives on
the website
[http:\\www.postgresql.org\]) about PostgreSQL vs MS SQL 6.5 for the
last 2 days or so.  
I think these ideas must come in threes, so where is that other person?

I can't really give a feature comparison of MS SQL 7.0 as I've never
used it. as for a benchmarking, although it is out of date, check
http://www.tcx.se/benchmark.html.  There is no direct comparison of
PostgreSQL and MS SQL but it might give you some idea of something (hey
I can't make heads or tails of it all, but remember a smaller bar is
better).
Oh well, hope this helps somebody somehow,
-DEJ

 -Original Message-
 Please forgive my newbieness but I am extremely new to both 
 Postgresql AND
 Linux. I've been a consultant for 6 years working mostly on Microsoft
 platforms (NT, MSSQL). I have developed many data-driven 
 websites using
 WinNT/IIS/ASP/MSSQL. Now, getting sick of MS and being 
 enamored with the
 whole Open Source movement, I wish to learn (and develop a 
 project or two)
 on Linux/Apache/PHP/PGSQL.
 
 I was wondering if anyone has done any benchmarking (even roughly),
 comparing PGSQL to Microsoft SQL Server 7.0 or even the older 
 MSSQL 6.5.
 Specifically I just want the reassurance that the two 
 products are in the
 same ballpark as far as performance goes. Has anyone done 
 this recently?
 
 Thank you,
 Bryan