Re: [DOCS] Partitioning documentation example

[Decibel!]

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,'_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

Re: [DOCS] Partitioning documentation example

[Tom Lane]

Decibel! <[EMAIL PROTECTED]> writes:
> On Fri, Jan 04, 2008 at 12:25:59PM -0500, Tom Lane wrote:
>> That won't actually work.

> I think it's still worthy as an example.

I think what we have here is a failure to communicate.  How are you
going to do performance measurement on something that does not work?

regards, tom lane

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings