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 <AVinogradovs@Clearpathnet.com> 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
> >
>
>