On Tue, 2006-02-14 at 15:05 -0800, Bryce Nesbitt wrote: <blockquote type="CITE"><pre>
<font color="#000000">Ken Hill wrote:</font>
<font color="#000000">>> also (hate to be obvious) have you analyzed lately?</font>
<font color="#000000">>> </font>
<font color="#000000">I'd say that's fair game, not obvious. Vacuum/Analyze is ar so aparent</font>
<font color="#000000">to a person moving</font>
<font color="#000000">to Postgres from other DB's.</font>
<font color="#000000">---------------------------(end of broadcast)---------------------------</font>
<font color="#000000">TIP 4: Have you searched our list archives?</font>
<font color="#000000"> <a
href="http://archives.postgresql.org">http://archives.</a></font>postgresql.org
</pre></blockquote> In my O'Reily "Practical PostgreSQL" book it recommends vacuuming a production database on a daily
basis.I liken this to MS Access' "compact/repair" procedure.