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

Re: Bulk loading/merging

From: "Worky Workerson" <worky(dot)workerson(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Bulk loading/merging
Date: 2006-05-26 19:04:59
Message-ID: ce4072df0605261204o7f027120m70b16c2f796cce5b@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
Another little question ... would using any sort of TEMP table help out, i.e.
loading the unaggregated data into a TEMP table, aggregating the data via a
SELECT INTO another TEMP table, and then finally INSERT ... SELECT into the
master, aggregated, triggered table?  It seems like this might be a win if
A) the TEMP tables fit into memory, and B) the load data aggregates well.
Worst case (i.e. all unique data in the load) seems like it might take much
longer, however, since I'm creating 2 new TEMP tables ....

In response to

pgsql-performance by date

Next:From: Merlin MoncureDate: 2006-05-26 19:40:22
Subject: Re: is it possible to make this faster?
Previous:From: Worky WorkersonDate: 2006-05-26 18:48:20
Subject: Bulk loading/merging

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