Received: from tech.com.au (IDENT:root@techpt.lnk.telstra.net [139.130.75.122]) by hub.org (8.9.3/8.9.3) with ESMTP id HAA98622; Thu, 3 Feb 2000 07:30:51 -0500 (EST) (envelope-from chris@bitmead.com) Received: from bitmead.com (tardis [203.41.180.243]) by tech.com.au (8.9.3/8.9.3) with ESMTP id XAA30791; Thu, 3 Feb 2000 23:28:31 +1100 Sender: chris@tech.com.au Message-ID: <3899746F.9869F4D8@bitmead.com> Date: Thu, 03 Feb 2000 23:28:31 +1100 From: Chris X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.12 i686) X-Accept-Language: en MIME-Version: 1.0 To: Bruce Momjian CC: Tom Lane , pgsql-hackers@postgreSQL.org, pgsql-sql@postgreSQL.org Subject: Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL References: <200002031213.HAA20196@candle.pha.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Bruce Momjian wrote: > > Well I see that pg_class has columns like "relhasindex". If we added a > > "relhassubclass", the overhead should be unmeasureable. > > Yes, but how do you keep that accurate? If I add indexes, then drop > them, does relhasindex go to false. I don't know. Does it? >Could you do that for relhassubclass? If we made it relnumsubclasses and incremented/decremented on CREATE/DROP, it seems easy in theory. -- Chris Bitmead mailto:chris@bitmead.com http://www.techphoto.org - Photography News, Stuff that Matters