On 7 November 2014 12:35, Dimitri Fontaine <dimi...@2ndquadrant.fr> wrote: > Simon Riggs <si...@2ndquadrant.com> writes: >> It would be more useful to work on the applications of this.... >> >> 1. INSERT into a table >> * Action start time >> * Schema >> * Tablename >> * Number of blocks in table >> which would then allow you to do these things run an assessment report >> showing which tables would be rewritten. > > That should be done by the user, from within his Event Trigger code. For > that to be possible, the previous patch was missing a way to expose the > OID of the table being rewritten, I've now added support for that. > >> 2. Get access to number of blocks, so you could limit rewrites only to >> smaller tables by putting a block limit in place. > > Also, I did expand the docs to fully cover your practical use case of a > table_rewrite Event Trigger implementing such a table rewrite policy.
That looks complete, very useful and well documented. I'm looking to commit this tomorrow. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers