2009/9/29 Amitabh Kant <amitabhk...@gmail.com> > On Tue, Sep 29, 2009 at 1:06 PM, György Vilmos <vilmos.gyo...@gmail.com>wrote: > >> Hello, >> >> I've done a benchmark of recent versions of PostgreSQL's last five major >> releases to see, how performance has changed during the past years from >> version to version. >> You can find the article here: >> http://suckit.blog.hu/2009/09/26/postgresql_history >> >> Thanks for working on this great piece of software! >> >> -- <http://suckit.blog.hu/> >> >> > Hello > > Thanks for the benchmark. Did you configure FreeBSD kernel parameters too, > or used the default values? > > kern.ipc.shmall=393216 kern.ipc.shmmax=1610612736 kern.ipc.semmap=256 kern.ipc.shm_use_phys=1 kern.smp.topology="8" kern.timecounter.smp_tsc=1 kern.timecounter.hardware="TSC"
smp.topology was needed because the current kernel doesn't recognize the correct cache topology on this machine. -- http://suckit.blog.hu/