Re: GiST index on data types that require compression

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Re: GiST index on data types that require compression
Дата
Msg-id 3B0E6F72.4090209@stack.net
обсуждение исходный текст
Ответ на Re: GiST index on data types that require compression  (Oleg Bartunov <oleg@sai.msu.su>)
Ответы Re: GiST index on data types that require compression  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> What I find just about as objectionable as the old haskeytype hack is
> that the user has to tell you whether the index is lossy or not.  This
> should be a property available from the system catalogs.  Not sure where
> to put it; do we need another column in pg_opclass, or is someplace
> other than the opclass needed?
> 

So, may by add to pg_opclass two fields?
bool is_varlena_key
bool is_lossy_compress

Then index_formtuple must look at is_varlena_key and 'with (islossy)' 
could be determined automatically by view at used ops.



-- 
Teodor Sigaev
teodor@stack.net




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PQsetdbLogin bug?
Следующее
От: Teodor Sigaev
Дата:
Сообщение: Re: GiST index on data types that require compression