By loading in bulks, I mean I load some 40-50 thousand rows at once into a table that already has some millions. Index rebuild on that table after each 50k inserts will be even less efficient ;)
Alex. On Fri, 2008-08-01 at 12:57 -0700, Joshua Drake wrote: > On Fri, 01 Aug 2008 12:41:12 -0700 > Alex Vinogradovs <[EMAIL PROTECTED]> wrote: > > > Guys, > > > > I was wondering if there is a btree indexing implementation that > > is not WAL-logged. I'm loading data in bulks, and index logging > > is an unnecessary overhead for me (easier to rebuild on crash). > > Drop the index during load? > > > > > Thanks! > > > > best regards, > > Alex Vinogradovs > > > > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
