Re: Configuring Shared Buffers

------=_Part_8184_15146385.1214869298384
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

No, i don't have autova***.
We tried it sometime ago, and the applications began to take "time-out".
I think we don't need autova***, along the day the application don't get
slow, sometimes is faster (maybe the use of the applications is less).
The actual machine is Dual Core Xeon 1.5 and 2 Gb RAM.


2008/6/30 Alvaro Herrera <alvherre@[EMAIL PROTECTED]
>:

> Rafael Domiciano escribi=F3:
> > 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".
>
> Have you tuned autovacuum?  Maybe you need it to be more frequent on
> certain tables or something.
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>

------=_Part_8184_15146385.1214869298384
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

No, i don&#39;t have autova***.<br>We tried it sometime ago, and the
applic=
ations began to take &quot;time-out&quot;.<br>I think we don&#39;t need
aut=
ova***, along the day the application don&#39;t get slow, sometimes is
fast=
er (maybe the use of the applications is less).<br>
The actual machine is Dual Core Xeon 1.5 and 2 Gb RAM.<br><br><br><div
clas=
s=3D"gmail_quote">2008/6/30 Alvaro Herrera &lt;<a
href=3D"mailto:alvherre@[EMAIL PROTECTED]
">alvherre@[EMAIL PROTECTED]
>&gt;:<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;">
Rafael Domiciano escribi=F3:<br>
<div class=3D"Ih2E3d">&gt; Yes, the server just does S, U, I and D.<br>
&gt; The queries is pretty simples, don&#39;t have huge joins across
tables=
....<br>
&gt; In this server I have around 500 tables, the largest are:<br>
&gt; 9 millions tuples | 5 millions tuples<br>
&gt;<br>
&gt; This server is our &quot;authenticator&quot;; the response is need to
=
be &quot;imediatly&quot;.<br>
&gt; Today, the monitoring of the server is done using the unix
command:<br=
>
&gt; loguptime<br>
&gt; With the time we discovered that when loguptime is up than 1.0 the
res=
ponse<br>
&gt; begin to late, and the applications begin to take
&quot;Time-out&quot;=
..<br>
<br>
</div>Have you tuned autovacuum? &nbsp;Maybe you need it to be more
frequen=
t on<br>
certain tables or something.<br>
<font color=3D"#888888"><br>
--<br>
Alvaro Herrera &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbs=
p; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<a
href=3D"http://www.Co=
mmandPrompt.com/" target=3D"_blank">http://www.CommandPrompt.com/</a><br>
The PostgreSQL Company - Command Prompt, Inc.<br>
</font></blockquote></div><br>

------=_Part_8184_15146385.1214869298384--