Re: managing kernel

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

In response to

Browse pgsql-general by date

  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