From: | Maarten Boekhold <maartenb(at)dutepp2(dot)et(dot)tudelft(dot)nl> |
---|---|
To: | Darren King <darrenk(at)insightdist(dot)com> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] char types gone. |
Date: | 1998-03-24 17:02:46 |
Message-ID: | Pine.SUN.3.91.980324180134.20092A-100000@dutepp2.et.tudelft.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, 24 Mar 1998, Darren King wrote:
> > > 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?
I think there's some confusion about which cache is meant. I think the
previous poster (ie. the one before darren) is thinking of processor
cache, be it first level or second level. Darren is probably meaning a
postgresql internal cache....
Maarten
_____________________________________________________________________________
| TU Delft, The Netherlands, Faculty of Information Technology and Systems |
| Department of Electrical Engineering |
| Computer Architecture and Digital Technique section |
| M(dot)Boekhold(at)et(dot)tudelft(dot)nl |
-----------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Klemm | 1998-03-24 17:31:56 | Re: [HACKERS] urgent: pgsql 6.3 FreeBSD port update trouble, --with-tcl doesn't work |
Previous Message | The Hermit Hacker | 1998-03-24 16:51:55 | Re: [HACKERS] Data type removal |