From: Rafael Domiciano <rafael.domiciano@gmail.com>
To: Tino Schwarze <postgresql@tisc.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: Configuring Shared Buffers
Date: Mon, 30 Jun 2008 20:16:02 -0300
Message-ID: <3a0028490806301616v6882a40bi2b54dcf63b37e315@mail.gmail.com> (raw)
In-Reply-To: <20080630191710.GC5358@easy2.in-chemnitz.de>
References: <3a0028490806301052y193a4aeayfcc6deafdeb1cdb2@mail.gmail.com>
<20080630182830.GA5358@easy2.in-chemnitz.de>
<3a0028490806301201m5e4c48d4qc51a880b8f80ecf5@mail.gmail.com>
<20080630191710.GC5358@easy2.in-chemnitz.de>
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 <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
> > 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 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ähren erblüht."
> > >
> > > 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ähren erblüht."
>
> 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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: rafael.domiciano@gmail.com, postgresql@tisc.de
Subject: Re: Configuring Shared Buffers
In-Reply-To: <3a0028490806301616v6882a40bi2b54dcf63b37e315@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox