Re: create table as select and transaction logging

Hi Michael

So are you saying that a "create table" cannot run without
"transaction logging"?

Regards


On Jan 22, 9:18 am, "Michael Dyer" <Michael.D...@xxxxxxxxxx> wrote:
Hi,
Transaction logs are used to record what you write to tables before the
table information is updated on disk or in cache.
This is used, whether the table is journalled or not.

There is an exception to this, which is 'bulk copying'.
Refer to the SQL guide under the 'copy' section in chapter 8.

Cheers,
Michael



-----Original Message-----
From: info-ingres-boun...@xxxxxxxxxxxxxxxxxxxxxxxxx

[mailto:info-ingres-boun...@xxxxxxxxxxxxxxxxxxxxxxxxx] On Behalf Of
euneve...@xxxxxxxxxxx
Sent: 22 January 2009 09:03
To: info-ing...@xxxxxxxxxxxxxxxxxxxxxxxxx
Subject: [Info-Ingres] create table as select and transaction logging

Hi

I have

           set autocommit on;
           set nojournaling;

           create table table-name as select
           with nojournaling;

I am using Ingres 2.6
and need to avoid journaling but the table create still appears to be
using (and exceeding) the transaction logs.

Regards
_______________________________________________
Info-Ingres mailing list
Info-Ing...@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx://www.kettleriverconsulting.com/mailman/listinfo/info-ingres- Hide quoted text -

- Show quoted text -

.

Relevant Pages