Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 67ADA650E81 for ; Mon, 30 Jun 2008 16:01:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 57149-07 for ; Mon, 30 Jun 2008 16:01:15 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.157]) by postgresql.org (Postfix) with ESMTP id 9A955650DBC for ; Mon, 30 Jun 2008 16:01:16 -0300 (ADT) Received: by fg-out-1718.google.com with SMTP id 16so898707fgg.23 for ; Mon, 30 Jun 2008 12:01:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type:references; bh=KG3uphIVcdLpk0G19jxCBoABZXavSlV6Ahnc35X+boE=; b=CnvjhNw+kHRE8RsaN08ppRA0BX2N7AsSoud/7Dig6qgKhUKrdGMW1gtMS3rp0YOrKw WVYpcf0i02no46x/rI52QHLkR4suwcfb0vx9X3tc7cA7X/6gzu+Bp90FmzAYs9LPJTa0 Oi5Px6c2aMntTGUgtEkVruNXzZY/Lcq68q1sk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:references; b=ilKlmMwPwkyIoc8hBO6ODE9RjHb9zC3QGO5iNMItqDO/EJPcXtOtR/QL8sdn5JZ+WT 2kO/tJlG6AXrhp2Tz7uTLoVTwwsbXozyCGQ5n1jO+d+MY1WvXSfOjVRMgGtyWt1U6Hn6 sPxW6a415V5WerXJ9K5fol+OWfVYErI0UWiF4= Received: by 10.86.25.17 with SMTP id 17mr6586860fgy.50.1214852474202; Mon, 30 Jun 2008 12:01:14 -0700 (PDT) Received: by 10.86.71.17 with HTTP; Mon, 30 Jun 2008 12:01:14 -0700 (PDT) Message-ID: <3a0028490806301201m5e4c48d4qc51a880b8f80ecf5@mail.gmail.com> Date: Mon, 30 Jun 2008 16:01:14 -0300 From: "Rafael Domiciano" To: "Tino Schwarze" Subject: Re: Configuring Shared Buffers Cc: pgsql-admin@postgresql.org In-Reply-To: <20080630182830.GA5358@easy2.in-chemnitz.de> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_7439_29471959.1214852474173" References: <3a0028490806301052y193a4aeayfcc6deafdeb1cdb2@mail.gmail.com> <20080630182830.GA5358@easy2.in-chemnitz.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.137 tagged_above=0 required=5 tests=AWL=0.136, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200806/252 X-Sequence-Number: 29590 ------=_Part_7439_29471959.1214852474173 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline The Postgres version is 8.3.3 and I am using Fedora Core 8. I have in the actual server around 70 connections the same time. I am assigning for this 100. 2008/6/30 Tino Schwarze : > On Mon, Jun 30, 2008 at 02:52:05PM -0300, Rafael Domiciano wrote: > > > Folks, I am configuring a new Postgres Server, that's gonna substitute > the > > critical server of the enterprise. > > I have a good machine: > > Quad-Core 2.5 Ghz > > 4 Gb RAM > > 1 Dedicated HD 300 Gb Sata for the PostgreSQL Directory > > If it's the "critical server", you'd want to use a RAID1 for the disk so > your server and data survives a harddisk crash. > > > My question is: > > How much I could assign for the "Shared Buffers" parameter? > > > > The default assigned now is 24 Mb. > > That's rather low. I suppose, you may safely say 200Mb here (check that > you don't run into OS limits, they might need raising). You may also > want to increase work_mem, but it depends on what the DB does, how many > concurrent connections you have etc. pp. maintenance_work_mem may safely > be set rather high - it speeds up vacuum etc. and is only used during > such operations. Also look for effective_cache_size and max_fsm_pages. > > BTW: What version are you going to use? > > Tino. > > -- > "What we nourish flourishes." - "Was wir n=E4hren erbl=FCht." > > www.craniosacralzentrum.de > www.forteego.de > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > ------=_Part_7439_29471959.1214852474173 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline The Postgres version is 8.3.3 and I am using Fedora Core 8.
I have in th= e actual server around 70 connections the same time. I am assigning for thi= s 100.


2008/6/30 Tino Schwarze <postgresql@tisc.de>:
On Mon, Jun 30, 2008 at 02:52:05PM -0300, Rafael Domiciano wrote:

> Folks, I am configuring a new Postgres Server, that's gonna substi= tute the
> critical server of the enterprise.
> I have a good machine:
> Quad-Core 2.5 Ghz
> 4 Gb RAM
> 1 Dedicated HD 300 Gb Sata for the PostgreSQL Directory

If it's the "critical server", you'd want to use a = RAID1 for the disk so
your server and data survives a harddisk crash.

> My question is:
> How much I could assign for the "Shared Buffers" parameter?<= br> >
> The default assigned now is 24 Mb.

That's rather low. I suppose, you may safely say 200Mb here (chec= k that
you don't run into OS limits, they might need raising). You may also want to increase work_mem, but it depends on what the DB does, how many
concurrent connections you have etc. pp. maintenance_work_mem may safely be set rather high - it speeds up vacuum etc. and is only used during
such operations. Also look for effective_cache_size and max_fsm_pages.

BTW: What version are you going to use?

Tino.

--
"What we nourish flourishes." - "Was wir n=E4hren erbl=FCht.= "

www.cranios= acralzentrum.de
www.forteego.de
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

------=_Part_7439_29471959.1214852474173--