Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 463F42E0174 for ; Thu, 29 Nov 2007 13:13:06 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 22995-05 for ; Thu, 29 Nov 2007 13:13:01 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 7822F2E00EE for ; Thu, 29 Nov 2007 13:13:01 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id lATHCtFw015648; Thu, 29 Nov 2007 12:12:55 -0500 (EST) To: "Joshua D. Drake" cc: Michael Paesold , NikhilS , David Fetter , "Jonah H. Harris" , PostgreSQL Docs , PostgreSQL Patches Subject: Re: [PATCHES] Partition: use triggers instead of rules In-reply-to: <474EE992.2050209@commandprompt.com> References: <20071128202615.GG24146@fetter.org> <21686.1196283184@sss.pgh.pa.us> <36e682920711281858x9a37039sa104036bf025de41@mail.gmail.com> <20071129031702.GU24146@fetter.org> <2854.1196315753@sss.pgh.pa.us> <20071128224154.06f950c9@commandprompt.com> <474EDAE2.3010705@gmx.at> <474EE25E.3080304@commandprompt.com> <14455.1196353045@sss.pgh.pa.us> <474EE992.2050209@commandprompt.com> Comments: In-reply-to "Joshua D. Drake" message dated "Thu, 29 Nov 2007 08:32:18 -0800" Date: Thu, 29 Nov 2007 12:12:55 -0500 Message-ID: <15647.1196356375@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/129 X-Sequence-Number: 4662 "Joshua D. Drake" writes: > Tom Lane wrote: >> A trigger >> will probably beat a rule for inserts/updates involving a small number >> of rows. > Which is exactly what partitioning is doing. Nonsense. Well, maybe *you* never do that, but if so you are hardly reflective of the whole world. regards, tom lane