Re: OLTP compression slow update
From: rjamya <rjamya_at_gmail.com>
Date: Thu, 27 Dec 2012 07:52:29 -0500
Message-ID: <CAGurbTO16z1LXNf7JM31=ZaWhyFJpCFPyvCSB3zx3eDxE=Aavg_at_mail.gmail.com>
I saw this first in early 10g versions of plain vanilla compression (not fancy oltp etc). We were analyzing http/smtp logs collected company-wide, Initially we had daily partitions. since it started getting large quickly (we had open web at that time), I introduced partition compression, it worked like magic. When updates (due to occasional re-loads, corrections, ranking etc) to compressed partitions took long, we redesigned our strategy. Kept 7 days worth of parttions uncompressed, and everything older was compressed. That worked out well in the end. I guess the update issue on compressed data still needs work then :) Raj
Date: Thu, 27 Dec 2012 07:52:29 -0500
Message-ID: <CAGurbTO16z1LXNf7JM31=ZaWhyFJpCFPyvCSB3zx3eDxE=Aavg_at_mail.gmail.com>
I saw this first in early 10g versions of plain vanilla compression (not fancy oltp etc). We were analyzing http/smtp logs collected company-wide, Initially we had daily partitions. since it started getting large quickly (we had open web at that time), I introduced partition compression, it worked like magic. When updates (due to occasional re-loads, corrections, ranking etc) to compressed partitions took long, we redesigned our strategy. Kept 7 days worth of parttions uncompressed, and everything older was compressed. That worked out well in the end. I guess the update issue on compressed data still needs work then :) Raj
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 27 2012 - 13:52:29 CET