On Fri, Oct 06, 2006 at 02:53:35PM -0400, Merlin Moncure wrote: > On 10/6/06, Scott Marlowe <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
