Received: from matt.w80.math-hat.com (zukerman-0.dsl.speakeasy.net [216.254.75.141]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5IEUia97686 for ; Mon, 18 Jun 2001 10:30:44 -0400 (EDT) (envelope-from zukerman@math-hat.com) Received: from zukerman by matt.w80.math-hat.com with local (Exim 3.22 #1 (Debian)) id 15C035-0001pZ-00 for ; Mon, 18 Jun 2001 10:30:39 -0400 To: pgsql-sql@postgresql.org Subject: Inheritance: Performance & Indexes Mail-Copies-To: never From: Itai Zukerman Date: 18 Jun 2001 10:30:39 -0400 Message-ID: <87k829zwq8.fsf@matt.w80.math-hat.com> Lines: 25 User-Agent: Gnus/5.090004 (Oort Gnus v0.04) Emacs/20.7 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200106/253 X-Sequence-Number: 3511 Just curious: create table a (x int4 primary key); create table a1 () inherits (a); [...] delete from a where x = 1000; I take it that this is equivalent to: delete from only a where x = 1000; delete from only a1 where x = 1000; In particular, for performance reasons I should try to limit the delete to a1 wherever possible? Also, it looks like a1 doesn't inherit the primary key index. Is that intentional or a bug? Finally, is it possible to specify that x values be unique across both a *and* a1, without triggers? -- Itai Zukerman