From: Josh Berkus <josh@agliodbs.com>
To: pgsql-performance@postgresql.org
Cc: 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 09:29:09 -0700
Message-ID: <200507270929.10251.josh@agliodbs.com> (raw)
In-Reply-To: <BF0BDD48.9FFF%llonergan@greenplum.com>
References: <BF0BDD48.9FFF%llonergan@greenplum.com>
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.
--
Josh Berkus
Aglio Database Solutions
San Francisco
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: 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: <200507270929.10251.josh@agliodbs.com>
* 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