Il 17/08/2010 15:44, Tom Lane ha scritto: <blockquote cite="mid:9280.1282052697@sss.pgh.pa.us" type="cite"><pre
wrap="">EdoardoInnocenti <a class="moz-txt-link-rfc2396E"
href="mailto:edoardo.innocenti@savinodelbene.com"><edoardo.innocenti@savinodelbene.com></a>writes:
</pre><blockquotetype="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
growfast, 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
mailprogram'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 /></div><pre class="moz-signature" cols="72"><font
face="Verdana"><b><fontcolor="#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><br /><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
aglialtri 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
ricevutoquesto 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'Aziendanon si assume alcuna responsabilità giuridica qualora pervengano da questo indirizzo messaggi estranei
all'attivitàlavorativa o contrari a norme. </small></div><br />