------=_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 <postgresql@[EMAIL PROTECTED]
>:
> 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@[EMAIL PROTECTED]
)
> 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.<br>I have in
th=
e actual server around 70 connections the same time. I am assigning for
thi=
s 100.<br><br><br><div class=3D"gmail_quote">2008/6/30 Tino Schwarze
<<a=
href=3D"mailto:postgresql@[EMAIL PROTECTED]
">postgresql@[EMAIL PROTECTED]
>>:<br>
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204,
=
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div
class=3D"Ih2=
E3d">On Mon, Jun 30, 2008 at 02:52:05PM -0300, Rafael Domiciano wrote:<br>
<br>
> Folks, I am configuring a new Postgres Server, that's gonna
substi=
tute the<br>
> critical server of the enterprise.<br>
> I have a good machine:<br>
> Quad-Core 2.5 Ghz<br>
> 4 Gb RAM<br>
> 1 Dedicated HD 300 Gb Sata for the PostgreSQL Directory<br>
<br>
</div>If it's the "critical server", you'd want to use a
=
RAID1 for the disk so<br>
your server and data survives a harddisk crash.<br>
<div class=3D"Ih2E3d"><br>
> My question is:<br>
> How much I could assign for the "Shared Buffers"
parameter?<=
br>
><br>
> The default assigned now is 24 Mb.<br>
<br>
</div>That's rather low. I suppose, you may safely say 200Mb here
(chec=
k that<br>
you don't run into OS limits, they might need raising). You may
also<br=
>
want to increase work_mem, but it depends on what the DB does, how
many<br>
concurrent connections you have etc. pp. maintenance_work_mem may
safely<br=
>
be set rather high - it speeds up vacuum etc. and is only used during<br>
such operations. Also look for effective_cache_size and max_fsm_pages.<br>
<br>
BTW: What version are you going to use?<br>
<br>
Tino.<br>
<br>
--<br>
"What we nourish flourishes." - "Was wir n=E4hren
erbl=FCht.=
"<br>
<br>
<a href=3D"http://www.craniosacralzentrum.de"
target=3D"_blank">www.cranios=
acralzentrum.de</a><br>
<a href=3D"http://www.forteego.de"
target=3D"_blank">www.forteego.de</a><br=
>
<font color=3D"#888888"><br>
--<br>
Sent via pgsql-admin mailing list (<a
href=3D"mailto:pgsql-admin@[EMAIL PROTECTED]
">pgsql-admin@[EMAIL PROTECTED]
>)<br>
To make changes to your subscription:<br>
<a href=3D"http://www.postgresql.org/mailpref/pgsql-admin"
target=3D"_blank=
">http://www.postgresql.org/mailpref/pgsql-admin</a><br>
</font></blockquote></div><br>
------=_Part_7439_29471959.1214852474173--
|
