Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 06F5C2E0093 for ; Wed, 6 Feb 2008 01:05:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 93073-02 for ; Wed, 6 Feb 2008 01:05:51 -0400 (AST) Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 21BCE2E2D62 for ; Wed, 6 Feb 2008 01:05:51 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id 2A2A756479; Wed, 6 Feb 2008 05:05:48 +0000 (UTC) Received: (hashcash-sendmail, from uid 1001); Tue, 5 Feb 2008 23:05:42 -0600 Date: Tue, 5 Feb 2008 23:05:42 -0600 From: Decibel! To: Tom Lane Cc: Bruce Momjian , Simon Riggs , PostgreSQL-documentation Subject: Re: Partitioning documentation example Message-ID: <20080206050542.GQ1212@decibel.org> References: <200801041527.m04FR7L19863@momjian.us> <17842.1199467559@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="AgMQdj1H+oflzkp9" Content-Disposition: inline In-Reply-To: <17842.1199467559@sss.pgh.pa.us> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:080206:tgl@sss.pgh.pa.us::S6sT+zn/E5fSjoD4:00000000000000000000 0000000000000000000000005Eo8 X-Hashcash: 1:20:080206:bruce@momjian.us::CR29IVB5UL1M+/L7:07/PK X-Hashcash: 1:20:080206:simon@2ndquadrant.com::XfoZNHGiLmHQ6avK:0000000000000000 0000000000000000000000008YVd X-Hashcash: 1:20:080206:pgsql-docs@postgresql.org::TnMxdL+0Xd5Yh2yj:000000000000 00000000000000000000000057+t X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/12 X-Sequence-Number: 4806 --AgMQdj1H+oflzkp9 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Jan 04, 2008 at 12:25:59PM -0500, Tom Lane wrote: > Bruce Momjian writes: > > EXECUTE 'INSERT INTO measurement_y' || to_char(NEW.logdate,'YYYY_mM= M') || ' VALUES (NEW.*)'; >=20 > 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? --=20 Decibel!, aka Jim C. Nasby, Database Architect decibel@decibel.org=20 Give your computer some brain candy! www.distributed.net Team #1828 --AgMQdj1H+oflzkp9 Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) iD8DBQFHqUAmdO30qud8SkgRArpjAJ9RU6T6uynC8rVqkOK18YE9tJhq2wCePVOE xGsDeVPTO8KPEekqjssLvpw= =ThGu -----END PGP SIGNATURE----- --AgMQdj1H+oflzkp9--