Re: [HACKERS] char types gone. - Mailing list pgsql-hackers

From darrenk@insightdist.com (Darren King)
Subject Re: [HACKERS] char types gone.
Date
Msg-id 9803241510.AA33040@ceodev
Whole thread Raw
Responses Re: [HACKERS] char types gone.  (Maarten Boekhold <maartenb@dutepp2.et.tudelft.nl>)
Re: [HACKERS] char types gone.  (dg@illustra.com (David Gould))
Re: [HACKERS] char types gone.  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
> > 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?

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?

darrenk

pgsql-hackers by date:

Previous
From: Mattias Kregert
Date:
Subject: Re: [HACKERS] char types gone.
Next
From: darrenk@insightdist.com (Darren King)
Date:
Subject: Re: [HACKERS] char types gone.