[GENERAL] Efficient map looking table

2012-01-10 Thread Yoann MOREAU
cause different inserts in tags table could occur at the same time, all checking for a tag name. I then would need the whole tag_names table to be loaded in memory and in the most "map" way as possible, is there anything special to do ? Thanks ! Yoann Moreau -- Sent via pgsql-

Re: [GENERAL] GIN : Working with term positions

2011-10-26 Thread Yoann Moreau
On 21/10/11 12:23, Yoann Moreau wrote: Hello, I'm using a GIN index for a text column on a big table. I use it to rank the rows, but I also need to get the term positions for each document of a subset of documents. I assume these positions are stored in the index, because doc says posi

[GENERAL] GIN : Working with term positions

2011-10-21 Thread Yoann Moreau
racters offset or string length are never used by the parsetext function (ts_parse.c). If you have any other suggestion, would love to hear that ! Regards, Yoann Moreau -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general