Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.8.8/8.7.5) with ESMTP id WAA01119 for ; Mon, 23 Mar 1998 22:27:19 -0500 (EST) Received: (from maillist@localhost) by candle.pha.pa.us (8.8.5/8.8.5) id WAA04091; Mon, 23 Mar 1998 22:27:51 -0500 (EST) From: Bruce Momjian Message-Id: <199803240327.WAA04091@candle.pha.pa.us> Subject: Re: [HACKERS] char types gone. To: darrenk@insightdist.com (Darren King) Date: Mon, 23 Mar 1998 22:27:50 -0500 (EST) Cc: pgsql-hackers@postgreSQL.org In-Reply-To: <9803232314.AA27808@ceodev> from "Darren King" at Mar 23, 98 06:14:58 pm X-Mailer: ELM [version 2.4 PL25] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > Would be nice if stuff like that (and the money and geometrics) could be > compiled in in the same manner that Apache is a basic web server that lets > you pick and choose modules/features you want to build into it. > > I don't know how big of a performance boost it provides in the cache, but > removing the functions associated with the char types shrank the pg_proc > table from 906 to 842 entries or a bit over 7%. > > Want to shrink it further? Of those remaining 842, _230_ are for the geometric > types! Throw in 25 more for the cash/money functions. Bloat city if you > never use these things. Thirty percent could be moved out to contrib and > not missed by most postgres users. > Yes, but if they are never referenced, the cache is empty for those types. Unless there is some performance change with their removal, why remove them? Disk space of binary? -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h)