Hi Christian: On Mon, Sep 14, 2015 at 1:54 PM, Christian Ramseyer <rc@xxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
