Skip site navigation (1) Skip section navigation (2)

Re: [Bizgres-general] Re: faster INSERT with possible

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: "Luke Lonergan" <llonergan(at)greenplum(dot)com>,"Hannu Krosing" <hannu(at)skype(dot)net>,"John A Meinel" <john(at)arbash-meinel(dot)com>,"Dan Harris" <fbsd(at)drivefaster(dot)net>,"bizgres-general" <bizgres-general(at)pgfoundry(dot)org>
Subject: Re: [Bizgres-general] Re: faster INSERT with possible
Date: 2005-07-27 16:29:09
Message-ID: 200507270929.10251.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

Responses

pgsql-performance by date

Next:From: Chris HooverDate: 2005-07-27 16:29:14
Subject: Re: Help with view performance problem
Previous:From: Tomeh, HusamDate: 2005-07-27 16:19:42
Subject: Re: "Vacuum Full Analyze" taking so long

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group