RE: Thumbs Up on Compression

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <ian@xxxxxxxxxxxxxxxxx>
  • Date: Tue, 25 Jan 2005 21:29:41 +0100

Hi Ian

>The performace increase wad better than I expected.  Results were very
>similar for the handful of pv_ids I tried.

The main problem of a compressed table (or partition) is the poor =
support of DML statements. That said, if you can either reorganize it =
when the data is mostly read-only or only do direct inserts, it's a =
great feature!

Just my 2 cents...

Other related posts: