> On Fri, Jan 05, 2007 at 12:47:08PM +0100, Mikael Carneholm wrote: > >> Take a look at the set of partitioning functions I wrote shortly after > >> the 8.1 release: > >> > >> http://www.studenter.hb.se/~arch/files/part_functions.sql > >> > >> You could probably work something out using those functions (as-is, or > >> as inspiration) together with pgAgent > >> (http://www.pgadmin.org/docs/1.4/pgagent.html) > >> > >> /Mikael > >> > Those are some great functions. > Well, they're less than optimal in one aspect: they add one rule per partition, making them unsuitable for OLTP type applications (actually: any application where insert performance is crucial). Someone with time and/or energy could probably fix that, I guess...patches are welcome :) /Mikael
