Karen Hill wrote:
> Oracle and Solaris are/were the choice combination to run Oracle on. I
> would think that with this being the case, SUN Microsystems must have
> optimized Solaris to be an excellent OS for Relational Database
> Management Systems.

Some benchmarks agree:
http://www.mysql.com/news-and-events...e_2006_19.html


> That being said, could using PostgreSQL on Sun's
> Solaris OS improve performance compared to other operating systems like
> Windows and Linux?

Have you seen http://www.sun.com/software/solaris/postgresql.jsp ?

>
> What about Sun Studio C compiler. I heard it produces really fast
> executables. Is it possible to use that compiler instead of gcc to
> compile PostgreSQL to get a faster PostgreSQL by taking advantage of
> Sun's C compiler producing a faster executable?
>
> We probably all have heard about Oracle's Linux distribution.
> Does
> Oracle's Linux distro provide better PostgreSQL/ RDBMS performance over
> Solaris 10 or Redhat distros?

Test it on your workload and tell us.

>
> regards,
>
> karen