| From: | Edoardo Innocenti <edoardo(dot)innocenti(at)savinodelbene(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: TopMemoryContext - Configuration Mistake? |
| Date: | 2010-08-17 15:10:22 |
| Message-ID: | 4C6AA65E.1020502@savinodelbene.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
<!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(dot)1282052697(at)sss(dot)pgh(dot)pa(dot)us" type="cite">
<pre wrap="">Edoardo Innocenti <a class="moz-txt-link-rfc2396E" href="mailto:edoardo(dot)innocenti(at)savinodelbene(dot)com"><edoardo(dot)innocenti(at)savinodelbene(dot)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(dot)1282052697(at)sss(dot)pgh(dot)pa(dot)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.org/pgsql-admin/2010-08/msg00126.php</a>
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.html</a>
<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_penale_616.html</a>
<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>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 3.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Kempter | 2010-08-17 20:38:39 | Error: missing chunk number for toast value |
| Previous Message | emmanuel clark | 2010-08-17 14:16:57 | installing Postgres 8.3 msi getting `Error` = 2888 |