> "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
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
> "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
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
> "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
> >>>>> "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" == 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
> 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
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.
>--
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
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
11 matches
Mail list logo