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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org,"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-28 00:41:05
Message-ID: 13604.1122511265@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
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 SchumacherDate: 2005-07-28 01:59:37
Subject: Re: Performance problems testing with Spamassassin 3.1.0
Previous:From: Josh BerkusDate: 2005-07-28 00:12:15
Subject: Re: Performance problems testing with Spamassassin 3.1.0 Bayes module.

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