| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew Schumacher | 2005-07-28 01:59:37 | Re: Performance problems testing with Spamassassin 3.1.0 |
| Previous Message | Josh Berkus | 2005-07-28 00:12:15 | Re: Performance problems testing with Spamassassin 3.1.0 Bayes module. |