Re: [GENERAL] Table partition - parent table use

2017-09-15 Thread Francisco Olarte
Luiz: 1st thing, do not top-quote. It's hard to read and I, personally, consider it insulting ( not the first time it's done, and for obvious reasons ). On Fri, Sep 15, 2017 at 4:24 PM, Luiz Hugo Ronqui wrote: > Our usage allows us to insert all rows into the hot partition, since its a > rare e

Re: [GENERAL] Table partition - parent table use

2017-09-15 Thread Francisco Olarte
Hi Luiz: On Thu, Sep 14, 2017 at 11:06 PM, Luiz Hugo Ronqui wrote: ... > We have a database with data being inserted for almost 10 years and no > policy defined to get rid of old records, even though we mostly use only the > current and last year's data. Some etl processes run on older data from