Martha Stewart called it a Good Thing when nis@xxxxxxxxxxxxx (Nis Jorgensen) wrote: > J. Andrew Rogers wrote: > >> We have been using PostgreSQL on Opteron servers almost since the >> Opteron was first released, running both 32-bit and 64-bit versions of >> Linux. Both 32-bit and 64-bit versions have been bulletproof for us, >> with the usual stability I've become accustomed to with both PostgreSQL >> and Linux. We have been running nothing but 64-bit versions on >> mission-critical systems for the last year with zero problems. >> >> The short story is that for us 64-bit PostgreSQL on Opterons is >> typically something like 20% faster than 32-bit on the same, and *much* >> faster than P4 Xeon systems they nominally compete with. > > Since you sound like you have done extensive testing: > > Do you have any data regarding whether to enable hyperthreading or not? > I realize that this may be highly dependant on the OS, application and > number of CPUs, but I would be interested in hearing your > recommendations (or others'). Um, Hyper-Threading? On AMD? Hyper-Threading is a feature only offered by Intel, on some Pentium 4 chips. It is not offered by AMD. For our purposes, this is no loss; database benchmarks have widely shown it to be a performance loser across various database systems. -- output = reverse("moc.enworbbc" "@" "enworbbc") http://linuxdatabases.info/info/languages.html Yes, for sparkling white chip prints, use low SUDSing DRAW....