On Fri, Oct 06, 2006 at 02:53:35PM -0400, Merlin Moncure wrote: > On 10/6/06, Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxx EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
