Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 91FA92E02BF for ; Sat, 12 Jan 2008 16:35:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 71494-09 for ; Sat, 12 Jan 2008 16:35:45 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 4373D2E027C for ; Sat, 12 Jan 2008 16:35:45 -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 m0CKZIED021685; Sat, 12 Jan 2008 15:35:18 -0500 (EST) To: "Julian Scarfe" cc: pgsql-performance@postgresql.org Subject: Re: Inheritance, unique keys and performance In-reply-to: <01a301c85552$24ab6270$0600a8c0@Wilbur> References: <01a301c85552$24ab6270$0600a8c0@Wilbur> Comments: In-reply-to "Julian Scarfe" message dated "Sat, 12 Jan 2008 19:34:23 +0000" Date: Sat, 12 Jan 2008 15:35:18 -0500 Message-ID: <21684.1200170118@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/106 X-Sequence-Number: 28345 "Julian Scarfe" writes: > Useing 8.1.9 I'm running into some performance issues with inheritance. > I've abstracted the situation below because otherwise there's lots of > spurious stuff, but I'll gladly provide the real EXPLAIN ANALYZE output if > necessary. Without the EXPLAIN ANALYZE output, nobody can say whether you have interpreted your performance problem correctly or not. regards, tom lane