Re: [osdldbt-general] dbt5 scale factor

[Mark W. <ma...@os...>]

Jim C. Nasby wrote:
> On Tue, Oct 31, 2006 at 12:54:39PM -0800, Mark Wong wrote:
>> Jim C. Nasby wrote:
>>> Also, keep in mind that starting in 8.2, PostgreSQL will not log loading
>>> data into a table if the table was created in the same transaction as
>>> the load. That would probably have a noticeable impact on loading time.
>> Oooh, I should try that for dbt-3.  Is that already in cvs?
> 
> IIRC it's been in there for a few months now. Note that it can't take
> that shortcut if PITR is enabled.

Hi Jim,

Just wanted to run this by you while I ran a bigger test.  Attached is a 
file that incorporates the load_table function you gave me a while ago. 
  Basically it does the CREATE TABLE, COPY, and VACUUM ANALYZE all in 
one call and uses the -1 (one) flag with psql.

Thanks,
Mark