Re: Performance Optimization for Dummies 2 - the SQL

On Fri, Oct 06, 2006 at 02:53:35PM -0400, Merlin Moncure wrote:
> On 10/6/06, Scott Marlowe <smarlowe(at)g2switchworks(dot)com> wrote:
> >On Fri, 2006-10-06 at 11:44, Carlo Stonebanks wrote:
> >> This didn't work right away, but DID work after running a VACUUM FULL. In
> >> other words, i was still stuck with a sequential scan until after the
> >> vacuum.
> >>
> >> I turned autovacuum off in order to help with the import, but was
> >perfoming
> >> an ANALYZE with every 500 rows imported.
>
> how did you determine that it is done every 500 rows? this is the
> default autovacuum paramater. if you followed my earlier

Note that that parameter doesn't mean you'll get an analyze every 500
rows.
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)