Postgres Pro
Downloads
Home   >   mailing lists

Tunning FreeeBSD and PostgreSQL - Mailing list pgsql-performance

From Stephen Howie
Subject Tunning FreeeBSD and PostgreSQL
Date
Msg-id 012701c34a14$9b60ce80$c40712ac@showie
Whole thread Raw
Responses Re: Tunning FreeeBSD and PostgreSQL
List pgsql-performance
Tree view
Tried to search the list but the search wasn't working.
 
I have a server running strictly PostgreSQL that I'm trying to tune for performance. The specs are
 
2 X 2.4 Athlon MP processors
2G Reg DDR
FreeBSD 4.8 SMP kernel complied
PostgreSQL 7.3.3
4 X 80G IDE Raid 5
 
My problem is that I have not totally put my head around the concepts of the shmmax, shmmaxpgs, etc....  As it pertains to my current setup and the shared mem values in postgresql.conf.  I'm looking for a good rule of thumb when approaching this.  Any help or direction would be greatly appreciated.
 
Thanks
Stephen Howie

pgsql-performance by date:

Previous
From: Paul Thomas
Date:
Subject: Re: Pgsql - Red Hat Linux - VS MySQL VS MSSQL
Next
From: Richard Huxton
Date:
Subject: Re: Tunning FreeeBSD and PostgreSQL