On Fri, Jan 04, 2008 at 12:25:59PM -0500, Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> 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 decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828
In response to
pgsql-docs by date
|Next:||From: Tom Lane||Date: 2008-02-06 05:35:43|
|Subject: Re: Partitioning documentation example |
|Previous:||From: Gurjeet Singh||Date: 2008-02-03 05:14:37|
|Subject: Re: Wrong query examples in docs|