Re: OLTP compression slow update
Date: Thu, 27 Dec 2012 10:50:35 -0800
Message-ID: <CAENwkM6miodkXJzG=Y3c7Yo2FS_Jr_j7QDeKqHWLDQCVXznv2A_at_mail.gmail.com>
Thanks all for the ressponse.
Still testing and will share results.
-Michael.
On Thu, Dec 27, 2012 at 4:52 AM, rjamya <rjamya_at_gmail.com> wrote:
> 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-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 27 2012 - 19:50:35 CET