From: Edoardo Innocenti <edoardo.innocenti@savinodelbene.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: TopMemoryContext - Configuration Mistake?
Date: Tue, 17 Aug 2010 17:10:22 +0200
Message-ID: <4C6AA65E.1020502@savinodelbene.com> (raw)
In-Reply-To: <9280.1282052697@sss.pgh.pa.us>
References: <4C6932DF.90102@savinodelbene.com>
<5923.1281974354@sss.pgh.pa.us>
<4C6A32F8.1070808@savinodelbene.com>
<9280.1282052697@sss.pgh.pa.us>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-15"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Il 17/08/2010 15:44, Tom Lane ha scritto:
<blockquote cite="mid:9280.1282052697@sss.pgh.pa.us" type="cite">
<pre wrap="">Edoardo Innocenti <a class="moz-txt-link-rfc2396E" href="mailto:edoardo.innocenti@savinodelbene.com"><edoardo.innocenti@savinodelbene.com></a> writes:
</pre>
<blockquote type="cite">
<pre wrap="">Query Plan:<br>
"HashAggregate (cost=4910.06..4910.19 rows=1 width=659)"
</pre>
</blockquote>
<pre wrap="">
Hm ... the planner seems to think that this is a small query that isn't
going to take long, which is a bit at odds with the fact that you're
running out of memory. I suspect that these rowcount estimates are
far too low, which would suggest that you need to make sure your
ANALYZE statistics are up-to-date, and perhaps raise the statistics
targets. Try to get the plan's estimated rowcounts to approximate
reality.
</pre>
</blockquote>
We have pg_autovacuum enable and we launch vacuumdb -z every weeks. <br>
These tables do not grow fast, 300 record max. Is it possible that <br>
the statistics are the cause?<br>
<blockquote cite="mid:9280.1282052697@sss.pgh.pa.us" type="cite">
<pre wrap="">BTW, you might want to think about turning off your mail program's
HTML option. What other people are seeing looks like this:
<a class="moz-txt-link-freetext" href="http://archives.postgresql.org/pgsql-admin/2010-08/msg00126.php">http://archives.postgresql.o...;
and it's not pretty.
regards, tom lane
</pre>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
<title></title>
<pre class="moz-signature" cols="72"><font face="Verdana"><b><font
color="#000000">Edoardo Innocenti
</font></b><small><font color="#000000">Infrastructure Coordinator</font></small>
<font color="#000000">
<b>SDB Information Technology</b>
<small>Phone: +39.055.3811222
Fax: +39.055.5201411</small></font></font></pre>
</div>
<br>
<html>
<head>
<meta content="text/html; charset=ISO-8859-1" http-equiv="content-type">
<title>disclaimer-sdb</title>
</head>
<body>
<div style="text-align: center; width: 620px; font-family: Verdana;">
<small>
Utilizziamo i dati personali che la riguardano esclusivamente per nostre finalità amministrative e contabili, anche quando li comunichiamo a terzi. Informazioni dettagliate, anche in ordine al Suo diritto di accesso e agli altri Suoi diritti, sono riportate alla pagina <a href="http://www.savinodelbene.com/news/privacy.html">http://www.savinodelbene.com/news/privacy.htm...;
<br>
Se avete ricevuto questo messaggio per errore Vi preghiamo di ritornarlo al mittente eliminandolo assieme agli eventuali allegati, ai sensi art. 616 codice penale <a href="http://www.savinodelbene.com/codice_penale_616.html">http://www.savinodelbene.com/codice_pena...;
<BR>
L'Azienda non si assume alcuna responsabilità giuridica qualora pervengano da questo indirizzo messaggi estranei all'attività lavorativa o contrari a norme.
</small>
</div>
</body>
</html>
</P>
</BODY>
</HTML>
<br>
</body>
</html>
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: edoardo.innocenti@savinodelbene.com, tgl@sss.pgh.pa.us
Subject: Re: TopMemoryContext - Configuration Mistake?
In-Reply-To: <4C6AA65E.1020502@savinodelbene.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