Josh Berkus <josh(at)agliodbs(dot)com> writes:
> 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.
This may not matter given point (a), but: point (b) is completely wrong.
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Matthew Schumacher||Date: 2005-07-28 01:59:37|
|Subject: Re: Performance problems testing with Spamassassin 3.1.0|
|Previous:||From: Josh Berkus||Date: 2005-07-28 00:12:15|
|Subject: Re: Performance problems testing with Spamassassin 3.1.0 Bayes module.|