Re: [Bizgres-general] Re: faster INSERT with possible - Mailing list pgsql-performance

From Tom Lane
Subject Re: [Bizgres-general] Re: faster INSERT with possible
Date
Msg-id 13604.1122511265@sss.pgh.pa.us
Whole thread Raw
In response to Re: [Bizgres-general] Re: faster INSERT with possible  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
Josh Berkus <josh@agliodbs.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

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Performance problems testing with Spamassassin 3.1.0 Bayes module.
Next
From: Matthew Schumacher
Date:
Subject: Re: Performance problems testing with Spamassassin 3.1.0