[OSM-dev] Namefinder - what to do

[Jon Burgess]

On Tue, 2008-01-22 at 16:25 +0000, Nick Black wrote:
> On Jan 22, 2008 4:05 PM, Tom Hughes <tom at compton.nu> wrote:
> > In message
> <223020e60801220443h78d1575gd1ecec230167831c at mail.gmail.com>
> >         Nick Black <nickblack1 at gmail.com> wrote:
> >
> > > If we create an index on the way_tags k & v column we can directly
> > > search live data and retain the vast majority of the functionality
> of
> > > the namefinder search.  This obviously leaves the nodes being
> > > unsearchable.  So I'm going to look at moving node tags into a
> > > node_tags table.
> >
> > Splitting out the node tags is good. I suspect they are quite
> > inefficient at the moment as they make the node records variable
> > length. Plus splitting them out lets us have full text indexes
> > on the tags although that does force us to use MyISAM for the
> > tags table.
> >
> > > TomH: what do you think about creating a full text index on
> way_tags k & v?
> 
> Ok, so we can roll creating node_tags, migrating from nodes.tags to
> nodes_tags and a k + v full text index into one set of
> uber-migrations.
> 
An update to the planet dump code will also be required. The code should
be a clone of what we do already for the ways tags. Please remind me to
take a look when the changes occur. 

	Jon