[Bizgres-general] Re: [PERFORM] faster INSERT with possible

[Hannu Krosing]

On K, 2005-07-27 at 09:29 -0700, Josh Berkus wrote:
> Luke,
> 
> > Well - now that I test it, it appears you are correct, temp table COPY
> > bypasses WAL - thanks for pointing it out!
> 
> RIght.  The problem is bypassing WAL for loading new "scratch" tables which 
> aren't TEMPORARY tables.   We need to do this for multi-threaded ETL, since:
> a) Temp tables can't be shared by several writers, and
> b) you can't index a temp table.

I index then all the time

> 
-- 
Hannu Krosing <hannu at skype.net>