#include "hstore.h" #include "access/gist.h" #include "access/itup.h" /*#include "access/rtree.h"*/ #include "crc32.h" /* bigint defines */ #define BITBYTE 8 #define SIGLENINT 4 /* >122 => key will toast, so very slow!!! */ #define SIGLEN ( sizeof(int)*SIGLENINT ) #define SIGLENBIT (SIGLEN*BITBYTE) typedef char BITVEC[SIGLEN]; typedef char *BITVECP; #define SIGPTR(x) ( (BITVECP) ARR_DATA_PTR(x) ) #define LOOPBYTE(a) \ for(i=0;i> (i)) & 0x01 ) #define CLRBIT(x,i) GETBYTE(x,i) &= ~( 0x01 << ( (i) % BITBYTE ) ) #define SETBIT(x,i) GETBYTE(x,i) |= ( 0x01 << ( (i) % BITBYTE ) ) #define GETBIT(x,i) ( (GETBYTE(x,i) >> ( (i) % BITBYTE )) & 0x01 ) #define HASHVAL(val) (((unsigned int)(val)) % SIGLENBIT) #define HASH(sign, val) SETBIT((sign), HASHVAL(val)) typedef struct { int4 len; int4 flag; char data[1]; } GISTTYPE; #define ALLISTRUE 0x04 #define ISALLTRUE(x) ( ((GISTTYPE*)x)->flag & ALLISTRUE ) #define GTHDRSIZE ( sizeof(int4)*2 ) #define CALCGTSIZE(flag) ( GTHDRSIZE+(((flag) & ALLISTRUE) ? 0 : SIGLEN) ) #define GETSIGN(x) ( (BITVECP)( (char*)x+GTHDRSIZE ) ) #define SUMBIT(val) ( \ GETBITBYTE((val),0) + \ GETBITBYTE((val),1) + \ GETBITBYTE((val),2) + \ GETBITBYTE((val),3) + \ GETBITBYTE((val),4) + \ GETBITBYTE((val),5) + \ GETBITBYTE((val),6) + \ GETBITBYTE((val),7) \ ) #ifdef GEVHDRSZ #define GETENTRY(vec,pos) ((GISTTYPE *) DatumGetPointer((vec)->vector[(pos)].key)) #else #define GETENTRY(vec,pos) ((GISTTYPE *) DatumGetPointer(((GISTENTRY *) VARDATA(vec))[(pos)].key)) #endif #define WISH_F(a,b,c) (double)( -(double)(((a)-(b))*((a)-(b))*((a)-(b)))*(c) ) PG_FUNCTION_INFO_V1(ghstore_in); Datum ghstore_in(PG_FUNCTION_ARGS); PG_FUNCTION_INFO_V1(ghstore_out); Datum ghstore_out(PG_FUNCTION_ARGS); Datum ghstore_in(PG_FUNCTION_ARGS) { elog(ERROR, "Not implemented"); PG_RETURN_DATUM(0); } Datum ghstore_out(PG_FUNCTION_ARGS) { elog(ERROR, "Not implemented"); PG_RETURN_DATUM(0); } PG_FUNCTION_INFO_V1(ghstore_consistent); PG_FUNCTION_INFO_V1(ghstore_compress); PG_FUNCTION_INFO_V1(ghstore_decompress); PG_FUNCTION_INFO_V1(ghstore_penalty); PG_FUNCTION_INFO_V1(ghstore_picksplit); PG_FUNCTION_INFO_V1(ghstore_union); PG_FUNCTION_INFO_V1(ghstore_same); Datum ghstore_consistent(PG_FUNCTION_ARGS); Datum ghstore_compress(PG_FUNCTION_ARGS); Datum ghstore_decompress(PG_FUNCTION_ARGS); Datum ghstore_penalty(PG_FUNCTION_ARGS); Datum ghstore_picksplit(PG_FUNCTION_ARGS); Datum ghstore_union(PG_FUNCTION_ARGS); Datum ghstore_same(PG_FUNCTION_ARGS); Datum ghstore_compress(PG_FUNCTION_ARGS) { GISTENTRY *entry = (GISTENTRY *) PG_GETARG_POINTER(0); GISTENTRY *retval = entry; if (entry->leafkey) { GISTTYPE *res = (GISTTYPE*)palloc(CALCGTSIZE(0)); HStore *toastedval = (HStore *) DatumGetPointer(entry->key); HStore *val = (HStore *) DatumGetPointer(PG_DETOAST_DATUM(entry->key)); HEntry *ptr = ARRPTR(val); char *words = STRPTR(val); memset(res,0,CALCGTSIZE(0)); res->len=CALCGTSIZE(0); while(ptr-ARRPTR(val) < val->size) { int h; h = crc32_sz((char*)(words+ptr->pos), ptr->keylen); HASH( GETSIGN(res), h); if ( !ptr->valisnull ) { h = crc32_sz((char *)(words+ptr->pos+ptr->keylen), ptr->vallen); HASH( GETSIGN(res), h); } ptr++; } if (val != toastedval) pfree(val); retval = (GISTENTRY *) palloc(sizeof(GISTENTRY)); gistentryinit(*retval, PointerGetDatum(res), entry->rel, entry->page, entry->offset, res->len, FALSE); } else if ( !ISALLTRUE(DatumGetPointer(entry->key)) ) { int4 i; GISTTYPE *res; BITVECP sign = GETSIGN(DatumGetPointer(entry->key)); LOOPBYTE( if ((sign[i] & 0xff) != 0xff) PG_RETURN_POINTER(retval); ); res = (GISTTYPE *) palloc(CALCGTSIZE(ALLISTRUE)); res->len = CALCGTSIZE(ALLISTRUE); res->flag = ALLISTRUE; retval = (GISTENTRY *) palloc(sizeof(GISTENTRY)); gistentryinit(*retval, PointerGetDatum(res), entry->rel, entry->page, entry->offset, res->len, FALSE); } PG_RETURN_POINTER(retval); } Datum ghstore_decompress(PG_FUNCTION_ARGS) { PG_RETURN_DATUM(PG_GETARG_DATUM(0)); } Datum ghstore_same(PG_FUNCTION_ARGS) { GISTTYPE *a = (GISTTYPE *) PG_GETARG_POINTER(0); GISTTYPE *b = (GISTTYPE *) PG_GETARG_POINTER(1); bool *result = (bool *) PG_GETARG_POINTER(2); if (ISALLTRUE(a) && ISALLTRUE(b)) *result = true; else if (ISALLTRUE(a)) *result = false; else if (ISALLTRUE(b)) *result = false; else { int4 i; BITVECP sa = GETSIGN(a), sb = GETSIGN(b); *result = true; LOOPBYTE( if (sa[i] != sb[i]) { *result = false; break; } ); } PG_RETURN_POINTER(result); } static int4 sizebitvec(BITVECP sign) { int4 size = 0, i; LOOPBYTE( size += SUMBIT(sign); sign = (BITVECP) (((char *) sign) + 1); ); return size; } static int hemdistsign(BITVECP a, BITVECP b) { int i,dist=0; LOOPBIT( if ( GETBIT(a,i) != GETBIT(b,i) ) dist++; ); return dist; } static int hemdist(GISTTYPE *a, GISTTYPE *b) { if ( ISALLTRUE(a) ) { if (ISALLTRUE(b)) return 0; else return SIGLENBIT-sizebitvec(GETSIGN(b)); } else if (ISALLTRUE(b)) return SIGLENBIT-sizebitvec(GETSIGN(a)); return hemdistsign( GETSIGN(a), GETSIGN(b) ); } static int4 unionkey(BITVECP sbase, GISTTYPE * add) { int4 i; BITVECP sadd = GETSIGN(add); if (ISALLTRUE(add)) return 1; LOOPBYTE( sbase[i] |= sadd[i]; ); return 0; } Datum ghstore_union(PG_FUNCTION_ARGS) { #ifdef GEVHDRSZ GistEntryVector *entryvec = (GistEntryVector *) PG_GETARG_POINTER(0); int4 len = entryvec->n; #else bytea *entryvec = (bytea *) PG_GETARG_POINTER(0); int4 len = (VARSIZE(entryvec) - VARHDRSZ) / sizeof(GISTENTRY); #endif int *size = (int *) PG_GETARG_POINTER(1); BITVEC base; int4 i; int4 flag = 0; GISTTYPE *result; MemSet((void *) base, 0, sizeof(BITVEC)); for (i = 0; i < len; i++) { if (unionkey(base, GETENTRY(entryvec, i))) { flag = ALLISTRUE; break; } } len = CALCGTSIZE(flag); result = (GISTTYPE *) palloc(len); *size = result->len = len; result->flag = flag; if (!ISALLTRUE(result)) memcpy((void *) GETSIGN(result), (void *) base, sizeof(BITVEC)); PG_RETURN_POINTER(result); } Datum ghstore_penalty(PG_FUNCTION_ARGS) { GISTENTRY *origentry = (GISTENTRY *) PG_GETARG_POINTER(0); /* always ISSIGNKEY */ GISTENTRY *newentry = (GISTENTRY *) PG_GETARG_POINTER(1); float *penalty = (float *) PG_GETARG_POINTER(2); GISTTYPE *origval = (GISTTYPE *) DatumGetPointer(origentry->key); GISTTYPE *newval = (GISTTYPE *) DatumGetPointer(newentry->key); *penalty=hemdist(origval,newval); PG_RETURN_POINTER(penalty); } typedef struct { OffsetNumber pos; int4 cost; } SPLITCOST; static int comparecost(const void *a, const void *b) { return ((SPLITCOST *) a)->cost - ((SPLITCOST *) b)->cost; } Datum ghstore_picksplit(PG_FUNCTION_ARGS) { #ifdef GEVHDRSZ GistEntryVector *entryvec = (GistEntryVector *) PG_GETARG_POINTER(0); OffsetNumber maxoff = entryvec->n - 2; #else bytea *entryvec = (bytea *) PG_GETARG_POINTER(0); OffsetNumber maxoff = ((VARSIZE(entryvec) - VARHDRSZ) / sizeof(GISTENTRY)) - 2; #endif GIST_SPLITVEC *v = (GIST_SPLITVEC *) PG_GETARG_POINTER(1); OffsetNumber k, j; GISTTYPE *datum_l, *datum_r; BITVECP union_l, union_r; int4 size_alpha, size_beta; int4 size_waste, waste = -1; int4 nbytes; OffsetNumber seed_1 = 0, seed_2 = 0; OffsetNumber *left, *right; BITVECP ptr; int i; SPLITCOST *costvector; GISTTYPE *_k, *_j; nbytes = (maxoff + 2) * sizeof(OffsetNumber); v->spl_left = (OffsetNumber *) palloc(nbytes); v->spl_right = (OffsetNumber *) palloc(nbytes); for (k = FirstOffsetNumber; k < maxoff; k = OffsetNumberNext(k)) { _k = GETENTRY(entryvec, k); for (j = OffsetNumberNext(k); j <= maxoff; j = OffsetNumberNext(j)) { size_waste=hemdist(_k, GETENTRY(entryvec, j)); if (size_waste > waste ) { waste = size_waste; seed_1 = k; seed_2 = j; } } } left = v->spl_left; v->spl_nleft = 0; right = v->spl_right; v->spl_nright = 0; if (seed_1 == 0 || seed_2 == 0) { seed_1 = 1; seed_2 = 2; } /* form initial .. */ if (ISALLTRUE(GETENTRY(entryvec, seed_1))) { datum_l = (GISTTYPE *) palloc(GTHDRSIZE); datum_l->len = GTHDRSIZE; datum_l->flag = ALLISTRUE; } else { datum_l = (GISTTYPE *) palloc(GTHDRSIZE + SIGLEN); datum_l->len = GTHDRSIZE + SIGLEN; datum_l->flag = 0; memcpy((void *) GETSIGN(datum_l), (void *) GETSIGN(GETENTRY(entryvec, seed_1)), sizeof(BITVEC)) ; } if (ISALLTRUE(GETENTRY(entryvec, seed_2))) { datum_r = (GISTTYPE *) palloc(GTHDRSIZE); datum_r->len = GTHDRSIZE; datum_r->flag = ALLISTRUE; } else { datum_r = (GISTTYPE *) palloc(GTHDRSIZE + SIGLEN); datum_r->len = GTHDRSIZE + SIGLEN; datum_r->flag = 0; memcpy((void *) GETSIGN(datum_r), (void *) GETSIGN(GETENTRY(entryvec, seed_2)), sizeof(BITVEC)) ; } maxoff = OffsetNumberNext(maxoff); /* sort before ... */ costvector = (SPLITCOST *) palloc(sizeof(SPLITCOST) * maxoff); for (j = FirstOffsetNumber; j <= maxoff; j = OffsetNumberNext(j)) { costvector[j - 1].pos = j; _j = GETENTRY(entryvec, j); size_alpha = hemdist(datum_l,_j); size_beta = hemdist(datum_r,_j); costvector[j - 1].cost = abs(size_alpha - size_beta); } qsort((void *) costvector, maxoff, sizeof(SPLITCOST), comparecost); union_l=GETSIGN(datum_l); union_r=GETSIGN(datum_r); for (k = 0; k < maxoff; k++) { j = costvector[k].pos; if (j == seed_1) { *left++ = j; v->spl_nleft++; continue; } else if (j == seed_2) { *right++ = j; v->spl_nright++; continue; } _j = GETENTRY(entryvec, j); size_alpha = hemdist(datum_l,_j); size_beta = hemdist(datum_r,_j); if (size_alpha < size_beta + WISH_F(v->spl_nleft, v->spl_nright, 0.0001)) { if (ISALLTRUE(datum_l) || ISALLTRUE(_j) ) { if (!ISALLTRUE(datum_l)) MemSet((void *) union_l, 0xff, sizeof(BITVEC)); } else { ptr=GETSIGN(_j); LOOPBYTE( union_l[i] |= ptr[i]; ); } *left++ = j; v->spl_nleft++; } else { if (ISALLTRUE(datum_r) || ISALLTRUE(_j) ) { if (!ISALLTRUE(datum_r)) MemSet((void *) union_r, 0xff, sizeof(BITVEC)); } else { ptr=GETSIGN(_j); LOOPBYTE( union_r[i] |= ptr[i]; ); } *right++ = j; v->spl_nright++; } } *right = *left = FirstOffsetNumber; pfree(costvector); v->spl_ldatum = PointerGetDatum(datum_l); v->spl_rdatum = PointerGetDatum(datum_r); PG_RETURN_POINTER(v); } Datum ghstore_consistent(PG_FUNCTION_ARGS) { GISTTYPE *entry = (GISTTYPE*) DatumGetPointer( ((GISTENTRY *) PG_GETARG_POINTER(0))->key ); HStore *query=PG_GETARG_HS(1); bool res=true; HEntry *qe = ARRPTR(query); char *qv = STRPTR(query); BITVECP sign; if ( ISALLTRUE(entry) ) { PG_FREE_IF_COPY(query,1); PG_RETURN_BOOL(true); } sign=GETSIGN(entry); while(res && qe-ARRPTR(query) < query->size) { int crc = crc32_sz((char *)(qv + qe->pos), qe->keylen); if (GETBIT(sign,HASHVAL(crc))) { if ( !qe->valisnull ) { crc = crc32_sz((char *)(qv + qe->pos + qe->keylen), qe->vallen); if ( !GETBIT(sign,HASHVAL(crc)) ) res=false; } } else res=false; qe++; } PG_FREE_IF_COPY(query,1); PG_RETURN_BOOL(res); }