> 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.
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Chris Hoover||Date: 2005-07-27 16:29:14|
|Subject: Re: Help with view performance problem|
|Previous:||From: Tomeh, Husam||Date: 2005-07-27 16:19:42|
|Subject: Re: "Vacuum Full Analyze" taking so long|