From: | Thomas F(dot)O'Connell <tfo(at)sitening(dot)com> |
---|---|
To: | Dino Vliet <dino_vliet(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: managing kernel |
Date: | 2005-04-17 14:57:45 |
Message-ID: | eeaceeb450911bcd20afd83aa3777e2b@sitening.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | jao | 2005-04-17 19:39:28 | "Could not read block" during vacuum |
Previous Message | Todd Underwood | 2005-04-17 14:17:54 | increasingly slow insert/copy performance |