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

RES: [GENERAL] Table partition - parent table use

2017-09-15 Thread Luiz Hugo Ronqui
@postgresql.org [mailto:pgsql-general-owner+m233282=lronqui=tce.sp.gov...@postgresql.org] Em nome de Francisco Olarte Enviada em: sexta-feira, 15 de setembro de 2017 08:37 Para: Luiz Hugo Ronqui Cc: pgsql-general@postgresql.org Assunto: Re: [GENERAL] Table partition - parent table use Hi Luiz: On

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

[GENERAL] Table partition - parent table use

2017-09-14 Thread Luiz Hugo Ronqui
Hello everybody! I have searched quite a bit, but haven't found a setup like the ours, so I decided to ask if I'm missing something: 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