Re: [PERFORM] Massive table (500M rows) update nightmare

2010-01-08 Thread Eduardo Morras
At 08:17 07/01/2010, Carlo Stonebanks wrote: >Our DB has an audit table which is 500M rows and growing. (FYI the objects >being audited are grouped semantically, not individual field values). > >Recently we wanted to add a new feature and we altered the table to add a new >column. We are backfill

Re: [PERFORM] Compression in PG

2009-11-02 Thread Eduardo Morras
At 05:24 02/11/2009, you wrote: >The only reason I can think of for wanting to compress very small >datums is if you have a gajillion of them, they're highly >compressible, and you have extra CPU time coming out of your ears. In >that case - yeah, you might want to think about pre-compressing the