| From: | Francisco Olarte <folarte(at)peoplecall(dot)com> |
|---|---|
| To: | Christian Ramseyer <rc(at)networkz(dot)ch>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: GIN Trigram Index Size |
| Date: | 2015-09-14 14:34:23 |
| Message-ID: | CA+bJJbyMbn_z_Xnn6VCphJ6mc1yft=dbXfq8JDaVTgwYm+ALqQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi Christian:
On Mon, Sep 14, 2015 at 1:54 PM, Christian Ramseyer <rc(at)networkz(dot)ch> wrote:
> I agree with your append-only and disposable partition approach, it
> would work a lot better. The idea with using a second schema for
> selective backups is great, I'll totally steal this :)
Feel free. Just remember if you use redirection trigers/rules for
insert into the partitions it may lead to problems ( I do not normally
have them as I either use a partition aware dedicated inserter or zap
the archived tables from rules, as I only insert for the current date,
maintenance updates are done directly in the partitions ).
Francisco Olarte.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ingmar Brouns | 2015-09-14 15:11:52 | issue, dumping and restoring tables with table inheritance can alter column order |
| Previous Message | Jan de Visser | 2015-09-14 14:02:09 | Re: Ubuntu installed postgresql password failure |