Re: [PERFORM] Tunning FreeeBSD and PostgreSQL

2003-07-22 Thread Vivek Khera
> "BM" == Bruce Momjian <[EMAIL PROTECTED]> writes: BM> I know Linux has pagable shared memory, and you can resize the maximum BM> in a running kernel, so it seems they must have abandonded the linkage BM> between shared page tables and the kernel. This looks interesting: Thanks for the info

Re: [PERFORM] Tunning FreeeBSD and PostgreSQL

2003-07-22 Thread Bruce Momjian
Vivek Khera wrote: > > "BM" == Bruce Momjian <[EMAIL PROTECTED]> writes: > > >> not anything pre-allocated (from my understanding). These settings > >> allow for up to 100,000 shared buffers (I currently only use 30,000 > >> buffers) > > BM> I think the only downside to making them too big i

Re: [PERFORM] Tunning FreeeBSD and PostgreSQL

2003-07-22 Thread Vivek Khera
> "BM" == Bruce Momjian <[EMAIL PROTECTED]> writes: >> not anything pre-allocated (from my understanding). These settings >> allow for up to 100,000 shared buffers (I currently only use 30,000 >> buffers) BM> I think the only downside to making them too big is that you allocate BM> page tabl

Re: [PERFORM] Tunning FreeeBSD and PostgreSQL

2003-07-21 Thread Bruce Momjian
Vivek Khera wrote: > > "SH" == Stephen Howie <[EMAIL PROTECTED]> writes: > > SH> Richard- > SH> That was very helpfull Thanks! > SH> I still would like some guidance on tunning FreeBSD (shmmax and shmmaxpgs). > SH> Do I need to even touch these settings? > > Here's what I use on FreeBSD 4.7/4

Re: [PERFORM] Tunning FreeeBSD and PostgreSQL

2003-07-15 Thread Vivek Khera
> "SH" == Stephen Howie <[EMAIL PROTECTED]> writes: SH> Vivek, SH> Thanks, for your reply. May I ask what you system setup is like (i.e. SH> memory and such)? Current box is dual P3 1GHz and 2GB RAM. RAID0+1 on 4 disks. I'm about to order a bigger box, since I'm saturating the disk bandwi

Re: [PERFORM] Tunning FreeeBSD and PostgreSQL

2003-07-15 Thread Stephen Howie
Re: [PERFORM] Tunning FreeeBSD and PostgreSQL > >>>>> "SH" == Stephen Howie <[EMAIL PROTECTED]> writes: > > SH> Richard- > SH> That was very helpfull Thanks! > SH> I still would like some guidance on tunning FreeBSD (shmmax and shmmaxpgs). &

Re: [PERFORM] Tunning FreeeBSD and PostgreSQL

2003-07-15 Thread Vivek Khera
> "SH" == Stephen Howie <[EMAIL PROTECTED]> writes: SH> Richard- SH> That was very helpfull Thanks! SH> I still would like some guidance on tunning FreeBSD (shmmax and shmmaxpgs). SH> Do I need to even touch these settings? Here's what I use on FreeBSD 4.7/4.8. The kernel settings don't hurt

Re: [PERFORM] Tunning FreeeBSD and PostgreSQL

2003-07-14 Thread Nick Fankhauser
> I still would like some guidance on tunning FreeBSD (shmmax and > shmmaxpgs). > Do I need to even touch these settings? Stephen- I have no idea what these are set to by default in FreeBSD, but here's the page that covers changing it in the postgresql docs: http://www.postgresql.org/docs/7.3/st

Re: [PERFORM] Tunning FreeeBSD and PostgreSQL

2003-07-14 Thread Stephen Howie
Richard- That was very helpfull Thanks! I still would like some guidance on tunning FreeBSD (shmmax and shmmaxpgs). Do I need to even touch these settings? Stephen Howie >There are two articles recently posted here: > >http://www.varlena.com/GeneralBits/ > >They should provide a good start. >--

Re: [PERFORM] Tunning FreeeBSD and PostgreSQL

2003-07-14 Thread Richard Huxton
On Monday 14 Jul 2003 3:31 pm, Stephen Howie wrote: [snip] > 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 app

[PERFORM] Tunning FreeeBSD and PostgreSQL

2003-07-14 Thread Stephen Howie
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