Hello to all,
I realized index for moving objects in PostgreSQL DB, using GisT and I want
to write an article in the conference. It will be not a scientific paper,
but application track.
Can anybody tell the conference where I could publish my work ? :)
Best regards,
Sergej Galkin
Hello all,
Now I'm trying to realize index in GiST. Everything is Ok, but I would like
to know about advanced index programming options.
1) For example - can I delete entry in my picksplit procedure ?
2) Or to add logical conditions - when picksplit node ? For exampe change
default "when number o
*a, BOX *b)*
*{*
**
*if (b->low.x > a->x_low)*
*return 0;*
*if (b->low.y > a->y_low)*
*return 0;*
*if (b->high.x < a->x_high)*
*return 0;*
*if (b->high.y < a->y_high)*
*return 0;*
*return 1;*
*}
**
Do you have any ideas ?**
Best regards,
Sergej Galkin
*
is is the procedure obj contains
On Wed, Jan 13, 2010 at 8:56 PM, Sergej Galkin wrote:
> I want to add than I have a piece of my code that looks very strange
>
> Datum gist_mov_penalty(PG_FUNCTION_ARGS)
> {
> GISTENTRY *origentry = (GISTENTRY *) PG_GETARG_POINTER(0);
> GI
u have any ideas where is the problem ? :)
Best regards,
Sergej Galkin
On Wed, Jan 13, 2010 at 8:42 PM, Sergej Galkin wrote:
> Hello all,
>
> I am a student-magister and I'm writting my magister work. I realized gist
> index TPR tree - it is like a simple R tree but moving :)
>
);
* moving_object *orig = &(*origentry).key;
make_now(orig);
moving_object *new = &(*origentry).key;
make_now(new);*
Is everything ok in this code ??
On Wed, Jan 13, 2010 at 8:42 PM, Sergej Galkin wrote:
> Hello all,
>
> I am a student-magister and I'm writti
.
Best regards,
Sergej Galkin
moving_object.rar
Description: Binary data
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
es g++ (it is c++ compiler)).
But I know that c++ compiler uses iostream files, and the are on my paths.
Where can I get iosteam.h file ?
Best regards,
Sergej Galkin
(pageunion->y_low > curr->y_low)
pageunion->y_low = curr->y_low;
}
*sizep = sizeof(moving_object);
PG_RETURN_POINTER(pageunion);
}*
*
Can anybody know what the problem ? I imagine that my defined function
returns not pointer, but stucture (??) ?
Best regards,
Sergej Galkin
es of such functions as union, pentaly and
etc. And to read more detally than in PostgreSql documentation ?
2) How could I save in index structure index created time, and to get this
value when I envoking such procedures such as union, penalty, pick split ?
Best regards,
Sergej Galkin
Hello,
I am Oracle developer for 2 years, and I have a magister work - to realize
TPR index on RDBMS :) I desided to realize TPR index on PostgreSql RDBMS. I
am really new programmer in C language.
what I done
1 Installed Xubuntu on my computer.
2 build and installed PostgreSql.
3 Installed Anjuta
11 matches
Mail list logo