Re: [HACKERS] char types gone.

Поиск
Список
Период
Сортировка
От darrenk@insightdist.com (Darren King)
Тема Re: [HACKERS] char types gone.
Дата
Msg-id 9803241510.AA33040@ceodev
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Mattias Kregert
Дата:
Сообщение: Re: [HACKERS] char types gone.
Следующее
От: darrenk@insightdist.com (Darren King)
Дата:
Сообщение: Re: [HACKERS] char types gone.