From: Tom Lane <tgl@sss.pgh.pa.us>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-performance@postgresql.org, "Luke Lonergan" <llonergan@greenplum.com>
Cc: Hannu Krosing <hannu@skype.net>
Cc: John A Meinel <john@arbash-meinel.com>
Cc: Dan Harris <fbsd@drivefaster.net>
Cc: bizgres-general <bizgres-general@pgfoundry.org>
Subject: Re: [Bizgres-general] Re: faster INSERT with possible
Date: Wed, 27 Jul 2005 20:41:05 -0400
Message-ID: <13604.1122511265@sss.pgh.pa.us> (raw)
In-Reply-To: <200507270929.10251.josh@agliodbs.com>
References: <BF0BDD48.9FFF%llonergan@greenplum.com>
<200507270929.10251.josh@agliodbs.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, josh@agliodbs.com, llonergan@greenplum.com, hannu@skype.net, john@arbash-meinel.com, fbsd@drivefaster.net, bizgres-general@pgfoundry.org
Subject: Re: [Bizgres-general] Re: faster INSERT with possible
In-Reply-To: <13604.1122511265@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox