On Fri, Jan 04, 2008 at 12:25:59PM -0500, Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > EXECUTE 'INSERT INTO measurement_y' || > > to_char(NEW.logdate,'YYYY_mMM') || ' VALUES (NEW.*)'; > > That won't actually work. Even if it did, I don't think we should be > recommending use of EXECUTE here; the performance implications are bad.
I think it's still worthy as an example. Not all partitioning systems need a high insert rate. And even if it does, that tends to be CPU-work; if you're partitioning you're likely IO-bound and not CPU-bound. Has anyone measured the performance difference? -- Decibel!, aka Jim C. Nasby, Database Architect [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828
pgpDoUfeTUJLt.pgp
Description: PGP signature
