Re: [pgsql-performance] [GENERAL] Large databases, performance

Поиск
Список
Период
Сортировка
От Manfred Koizar
Тема Re: [pgsql-performance] [GENERAL] Large databases, performance
Дата
Msg-id hnf8quog5p54tf4tu0i12v00bc6bc9h0f2@4ax.com
обсуждение исходный текст
Ответ на Re: [pgsql-performance] [GENERAL] Large databases, performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Wed, 09 Oct 2002 09:32:50 -0400, Tom Lane <tgl@sss.pgh.pa.us>
wrote:
>Coupla quick comments on these:

My first attempt on user types; thanks for the tips.

>These functions are dangerous as written, because they will crash on
>null inputs.  I'd suggest marking them strict in the function
>declarations.

I was not aware of this, just wondered why bpchar routines didn't
crash :-)  Fixed.

>Some attention to volatility declarations (isCachable
>or isImmutable) would be a good idea too.
>Also, it'd be faster and more portable to write the functions with
>version-1 calling conventions.

Done, too.  In the meantime I've found out why it crashed with 7.3:
INSERT INTO pg_opclass  is now obsolete, have to use  CREATE OPERATOR
CLASS ...

Servus
 Manfred

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Justin Clift
Дата:
Сообщение: Re: [GENERAL] Point in Time Recovery WAS: Hot Backup
Следующее
От: Rod Taylor
Дата:
Сообщение: Re: [GENERAL] Point in Time Recovery WAS: Hot Backup