"Brian Neu" schrieb: > This may be an antiquated topic, but I'm still a little fuzzy on this 64bit vs > 32bit thing when it comes to performance. I know that 32 bit operating systems > and software can run faster than the 64 bit OS and software in certain > environments. However, I'm curious if a Postgres server handling dbmail would > qualify as one of those faster on 32 bit, or on 64 bit. > > I do see in the Postgres Solaris FAQ: > > "And on other hand,32-bit code on the AMD64 CPU family is not native, and > that is why 32-bit code is significant slower on this CPU family." > > I guess if my processor ends up being either an Opteron or modern Xeon that > would settle this.. . . . But if someone has a very firm understanding of this > that could confirm, that would be appreciated. Hello!
I'm not familiar with Postgres, but with MySQL. On 32 Bit Systems one process can only handle 2 GByte of RAM. As MySQL is only 1 process with many threads, one instance can handle 2GByte of RAM only. Of course you can start another instance, which can handle other 2 GByte of RAM. You don't have this limitations on 64 Bit Systems. Which means, that you can make the caches as big as you like. If your processor waits at 2 or 3 GHz on a 32 or 64 bit system is unimportant, as the limiting factor is the available cache(RAM) and how long it takes to read the data from the harddisk. -- Lars Kneschke CTO OfficeSpot.Net Metaways Infosystems GmbH Pickhuben 2-4, D-20457 Hamburg eGroupWare Support: http://www.egroupware-support.net OfficeSpot.Net Collaboration Server: http://cs.officespot.net E-Mail: mailto:[EMAIL PROTECTED] Web: http://www.metaways.de Tel: +49 (0)40 317031-21 Fax: +49 (0)40 317031-921 Mobile: +49 (0)175 9304324 Metaways Infosystems GmbH - Sitz: D-22967 Tremsbüttel Handelsregister: Amtsgericht Ahrensburg HRB 4508 Geschäftsführung: Hermann Thaele, Lüder-H.Thaele _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
