IDS Forum

RE: Compression performance

Posted By: Andrew Grantham
Date: Thursday, 17 June 2010, at 11:59 a.m.

In Response To: RE: Compression performance (Peter_Logan@spartanstores.com)

In that case can it be broken down into years for example if its historical data? Or months even?

> To: ids@iiug.org
> From: Peter_Logan@spartanstores.com
> Subject: RE: Compression performance [20414]
> Date: Thu, 17 Jun 2010 11:42:26 -0400
>
> It's actually in an instance of historical data ... So, it's rarely
> accessed other than to add new rows ...
>
> Yes, it contains varchars ....
>
> Peter Logan
> Senior Database Administrator
> Phone: 616/878-8309
>
> From:
> "Andrew Grantham" <agrantha@hotmail.com>
> To:
> ids@iiug.org
> Date:
> 06/17/2010 11:39 AM
> Subject:
> RE: Compression performance [20412]
> Sent by:
> ids-bounces@iiug.org
>
> Peter,
>
> I am sure you have considered this already but its worth asking. Are you
> sure
> you need 2.5 billion rows online and available all the time? is this table
> not
> a candidate for archiving or splitting up? Also does the table contains
> chars
> where a varchar could be better used?
>
> Regards
>
> Andy G.
>
> > To: ids@iiug.org
> > From: Peter_Logan@spartanstores.com
> > Subject: Compression performance [20411]
> > Date: Thu, 17 Jun 2010 10:57:36 -0400
> >
> > IDS 11.50.fc6
> > Aix 6.1
> >
> > I have a table which contains approximately 2.4 billion rows. It's
> > currently fragmented over 13 fragments. It's approximately 210gb. I am
> > doing some testing with the compression feature. I started the
> > compression of this table about 25 hours ago. My question is, are there
> > certain environment or onconfig parameters that can be set to help with
> > the performance of the compression and repack statements?
> >
> > Thanks in advance for any help ....
> >
> > Peter Logan
> > Senior Database Administrator
> > Phone: 616/878-8309
> >
> >
> >
>
> *******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
> _________________________________________________________________
> http://clk.atdmt.com/UKM/go/197222280/direct/01/
> We want to hear all your funny, exciting and crazy Hotmail stories. Tell
> us
> now
>
>
> *******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>

_________________________________________________________________
http://clk.atdmt.com/UKM/go/195013117/direct/01/
We want to hear all your funny, exciting and crazy Hotmail stories. Tell us now

Messages In This Thread

• Compression performance
  Peter_Logan@spartanstores.com -- Thursday, 17 June 2010, at 10:57 a.m.
  • RE: Compression performance
    Andrew Grantham -- Thursday, 17 June 2010, at 11:13 a.m.
    • RE: Compression performance
      Peter_Logan@spartanstores.com -- Thursday, 17 June 2010, at 11:42 a.m.
      • RE: Compression performance
        Andrew Grantham -- Thursday, 17 June 2010, at 11:59 a.m.
  • Re: Compression performance
    John Miller iii -- Thursday, 17 June 2010, at 8:40 p.m.
    • Re: Compression performance
      Peter_Logan@spartanstores.com -- Friday, 18 June 2010, at 10:22 a.m.
  • Re: Compression performance
    Khaled Bentebal -- Friday, 18 June 2010, at 6:44 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.