Skip site navigation (1) Skip section navigation (2)

Re: Partitioning documentation example

From: Decibel! <decibel(at)decibel(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, Simon Riggs <simon(at)2ndquadrant(dot)com>,PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org>
Subject: Re: Partitioning documentation example
Date: 2008-02-06 05:05:42
Message-ID: 20080206050542.GQ1212@decibel.org (view raw or flat)
Thread:
Lists: pgsql-docs
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

Responses

pgsql-docs by date

Next:From: Tom LaneDate: 2008-02-06 05:35:43
Subject: Re: Partitioning documentation example
Previous:From: Gurjeet SinghDate: 2008-02-03 05:14:37
Subject: Re: Wrong query examples in docs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group