Re: managing kernel - Mailing list pgsql-general

From Thomas F.O'Connell
Subject Re: managing kernel
Date
Msg-id eeaceeb450911bcd20afd83aa3777e2b@sitening.com
Whole thread Raw
In response to Re: managing kernel  (Dino Vliet <dino_vliet@yahoo.com>)
List pgsql-general
You'll probably want to take a look at this performance tuning
reference:

http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html

and this annotated configuration file:

http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC

Strategic Open Source: Open Your i™

http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

On Apr 17, 2005, at 4:57 AM, Dino Vliet wrote:

> OK,
> I have RTFM:-)
> SHMALL    Total amount of shared memory available (bytes
> or pages)    if bytes, same as SHMMAX; if pages,
> ceil(SHMMAX/PAGE_SIZE)
>
> These values should be the same. I've changed that
> now.
>
> Still my second question is valid though. Are there
> any other values I should consider changing in order
> to boost performance.
> I'm using postgresql 7.4.
>
> Brgds
> Dino

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Help! "Access is Denied" Installation on WinXP rolled
Next
From: jao@geophile.com
Date:
Subject: "Could not read block" during vacuum