I'm having a big trouble with the index size! I have looked for a solution
in the internet, but the solutions that I found don't fit for me! 

  I developed a new data type using C and add this new type on PostgreSQL.
Basically, the data type is: (DateADT, DateADT) with some temporal rules
that I'm researching! The data type is ok; the in, out, receive and send
functions are ok; some operations are ok. But the index operators and
functions are not working properly! Actually I can use them, but in some
cases an error occurs about index row size.

  I'm sure that the functions in, out, receive and send are well
implemented. I think the problem is that the data type is really big and
needs a "big index".


  The implementation code of the data type is::


typedef struct t_periodo


            DateADT                       tvi;

            DateADT                       tvf;

}           Periodo;



  Any ideas to solve my problem? Perhaps increasing the BLOCKSIZE could be
one solution. Not very smart one, but can solve temporally my problem?!?!


  Thanks in advance!

Reply via email to