Re: [HACKERS] Gist consistent and compression

2009-05-03 Thread Yeb Havinga
Hi Dimitri, list It seems to me that what you're asking for is addressed indirectly in the possibility to make your internal data type a full SQL visible datatype. Then you store this new datatype directly in the table and index that. Instead of converting from external to internal type at con

Re: [HACKERS] Gist consistent and compression

2009-05-02 Thread Dimitri Fontaine
Hi, Le 1 mai 09 à 23:04, Yeb Havinga a écrit : An idea for possible improvement of query speed on gist indexes with a costly compression function. We have a gist index that uses a compressed internal datatype. The compression is with some cost (it involves a syscache lookup). [...] small

[HACKERS] Gist consistent and compression

2009-05-01 Thread Yeb Havinga
Hello list, An idea for possible improvement of query speed on gist indexes with a costly compression function. We have a gist index that uses a compressed internal datatype. The compression is with some cost (it involves a syscache lookup). The functions called by the consistent functions are