From: Decibel! <decibel@decibel.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: Simon Riggs <simon@2ndquadrant.com>
Cc: PostgreSQL-documentation <pgsql-docs@postgresql.org>
Subject: Re: Partitioning documentation example
Date: Tue, 5 Feb 2008 23:05:42 -0600
Message-ID: <20080206050542.GQ1212@decibel.org> (raw)
In-Reply-To: <17842.1199467559@sss.pgh.pa.us>
References: <200801041527.m04FR7L19863@momjian.us>
<17842.1199467559@sss.pgh.pa.us>
On Fri, Jan 04, 2008 at 12:25:59PM -0500, Tom Lane wrote:
> Bruce Momjian <bruce@momjian.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@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: decibel@decibel.org, tgl@sss.pgh.pa.us, bruce@momjian.us, simon@2ndquadrant.com
Subject: Re: Partitioning documentation example
In-Reply-To: <20080206050542.GQ1212@decibel.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox