Sounds like an opportunity for someone at Sun to fund a little research project. Any Sun/Postgresql hackers out there? Any Sun project managers lurking out there?
Ray On Tue, Nov 11, 2003 at 01:37:03PM -0500, Greg Spiegelberg wrote: > I did and had too many problems and performance issues. Solaris- > PostgreSQL just doesn't gel as wel as Linux-PostgreSQL. (ouch) > > If PostgreSQL were to get retooled to work with threads the way it > works between processes today for Solaris or if someone were to find > a tweak to make the Solaris scheduler more process-centric than > thread-centric (maybe via dispadmin(1)?) then I'm sure Solaris-PG would > clobber Linux-PG. > > I still spin up 7.3.3 on our Sun V480 4CPU, 8GB, 2 internal fibre > drives occasionally and our 7.3.3 on RedHat 7.3 with 2.4.20, 2 1.4GHz, > 2GB memory and 2 internal U160 kills it. I've tried the many options > for UFS and VxFS and EXT3 on Linux still beats it. The database I use > on the Sun comes from a pg_dump on the Linux system. > > But, IMHO Solaris 8 or 9 in comparison to Linux on like hardware, > databases, configurations and queries the latter will outperform the > former every time. -= IMHO =- > > The short answer to your question is yes, it will run on Solaris 9. > > Greg > > > Peter Eisentraut wrote: > >Danielle Cossette writes: > > > > > >>Could you please let me know if Postgres 7.1.3 will run on Solaris 9. > > > > > >Why don't you try it out? > > > > > -- > Greg Spiegelberg > Sr. Product Development Engineer > Cranel, Incorporated. > Phone: 614.318.4314 > Fax: 614.431.8388 > Email: [EMAIL PROTECTED] > Cranel. Technology. Integrity. Focus. > > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings ---------------------------------------------------------------------- Ray Ontko [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match