Received: from candle.pha.pa.us (root@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.8.8/8.7.5) with ESMTP id WAA17566 for ; Tue, 24 Mar 1998 22:46:14 -0500 (EST) Received: (from maillist@localhost) by candle.pha.pa.us (8.8.5/8.8.5) id VAA24516; Tue, 24 Mar 1998 21:39:50 -0500 (EST) From: Bruce Momjian Message-Id: <199803250239.VAA24516@candle.pha.pa.us> Subject: Re: [HACKERS] char types gone. To: darrenk@insightdist.com (Darren King) Date: Tue, 24 Mar 1998 21:38:35 -0500 (EST) Cc: pgsql-hackers@postgreSQL.org In-Reply-To: <9803241510.AA33040@ceodev> from "Darren King" at Mar 24, 98 10:10:05 am X-Mailer: ELM [version 2.4 PL25] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > > 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? > > How does the cache really work then? Does one pg disk block map to one buffer? > > When you say "the cache is empty for those types.", what do you mean? I believe the buffer page cache does load in those types if they are in the same page as a requsted type, but the relation/function caches only store in requested relations/functions, as far as I know. -- 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)