Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 99446650EC2 for ; Mon, 30 Jun 2008 20:16:09 -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 16897-09 for ; Mon, 30 Jun 2008 20:16:01 -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.158]) by postgresql.org (Postfix) with ESMTP id 306E0650EBA for ; Mon, 30 Jun 2008 20:16:05 -0300 (ADT) Received: by fg-out-1718.google.com with SMTP id 16so952494fgg.23 for ; Mon, 30 Jun 2008 16:16:03 -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=w0fgoSpUds8oIYGV0kubzlBSXKRiQpT+7s9KVixUUjI=; b=e63MoP+CqVIfuCuZaUwA0hJsf0B8UMXbgIq6bHiModgeVc5PBZKbksP5AYFynT8ShZ lY83oI7rTrJByR9MpXXxlA30pjcBRtsMt6oH7WgbhF3F0oP4ZHLyMvALU0qNFSxen5BQ Onkl9kSm6xrsa/LD9boqDqbK9SthqGb8YWzsw= 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=JgRMOlNVQw78zKz3Q1j2RRLnx9l4kCv0HpgFj+j4HU0OZCW4cYXHoMafwqrarnjYbf POuHfusOdCF1VXSHTZ/4EF73XbfdprB6H8NtexkYlYNLcwueOP57d8Xw5pfY7/0t9GCB uVrWwrOEBXmoCAPnFQOpwcnrtJDWreskuUufs= Received: by 10.86.98.10 with SMTP id v10mr6848741fgb.46.1214867762716; Mon, 30 Jun 2008 16:16:02 -0700 (PDT) Received: by 10.86.71.17 with HTTP; Mon, 30 Jun 2008 16:16:02 -0700 (PDT) Message-ID: <3a0028490806301616v6882a40bi2b54dcf63b37e315@mail.gmail.com> Date: Mon, 30 Jun 2008 20:16:02 -0300 From: "Rafael Domiciano" To: "Tino Schwarze" Subject: Re: Configuring Shared Buffers Cc: pgsql-admin@postgresql.org In-Reply-To: <20080630191710.GC5358@easy2.in-chemnitz.de> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_8150_15279041.1214867762706" References: <3a0028490806301052y193a4aeayfcc6deafdeb1cdb2@mail.gmail.com> <20080630182830.GA5358@easy2.in-chemnitz.de> <3a0028490806301201m5e4c48d4qc51a880b8f80ecf5@mail.gmail.com> <20080630191710.GC5358@easy2.in-chemnitz.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.12 tagged_above=0 required=5 tests=AWL=0.119, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200806/258 X-Sequence-Number: 29596 ------=_Part_8150_15279041.1214867762706 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Yes, the server just does S, U, I and D. The queries is pretty simples, don't have huge joins across tables... In this server I have around 500 tables, the largest are: 9 millions tuples | 5 millions tuples This server is our "authenticator"; the response is need to be "imediatly". Today, the monitoring of the server is done using the unix command: loguptime With the time we discovered that when loguptime is up than 1.0 the response begin to late, and the applications begin to take "Time-out". 2008/6/30 Tino Schwarze : > On Mon, Jun 30, 2008 at 04:01:14PM -0300, Rafael Domiciano wrote: > > 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. > > And what does the server do? Mainly SELECT / UPDATE / INSERT / DELETE, > how is workload distributed, are queries very complex or pretty simple > are there huge joins across many tables? > > How many tables do you have and what are the largest ones? Are we talking > about thousands of rows or millions or lots of millions? > > Tino. > > > > > 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 th= at > > > 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 ma= ny > > > 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 > > > > > -- > "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_8150_15279041.1214867762706 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Yes, the server just does S, U, I and D.
The queries is pretty simples, = don't have huge joins across tables...
In this server I have around = 500 tables, the largest are:
9 millions tuples | 5 millions tuples

This server is our "authenticator"; the response is need to b= e "imediatly".
Today, the monitoring of the server is done usi= ng the unix command: loguptime
With the time we discovered that when log= uptime is up than 1.0 the response begin to late, and the applications begi= n to take "Time-out".

2008/6/30 Tino Schwarze <postgresql@tisc.de>:
On Mon, Jun 30, 2008 at 04:01:14PM -0300, Rafael Domiciano wrote:
> 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<= br> > assigning for this 100.

And what does the server do? Mainly SELECT / UPDATE / INSERT / DELETE= ,
how is workload distributed, are queries very complex or pretty simple
are there huge joins across many tables?

How many tables do you have and what are the largest ones? Are we talking about thousands of rows or millions or lots of millions?

Tino.

> > > Folks, I am configuring a new Postgres Server, that's go= nna 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 us= e 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" p= arameter?
> > >
> > > 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 m= ay also
> > want to increase work_mem, but it depends on what the DB does, ho= w 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 du= ring
> > such operations. Also look for effective_cache_size and max_fsm_p= ages.
> >
> > BTW: What version are you going to use?
> >
> > Tino.
> >
> > --
> > "What we nourish flourishes." - "Was wir n=E4hren = erbl=FCht."
> >
> > w= ww.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
> >

--
"What we nourish flourishes." - "Was wi= r 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_8150_15279041.1214867762706--