[OSM-dev] Planned Maintenance

[Tom Hughes]

In message <46A9360B.2030103 at bretth.com>
        Brett Henderson <brett at bretth.com> wrote:

> Hi Tom is it possible to get an idea of what the changes are?  I checked 
> the rails_port\db\migrate directory and didn't see any new scripts.

I deliberately haven't committed it yet until I'm sure that it is
complete...

See my previous message for details of the changes.

> I'm particularly interested to see what impact any changes will have on 
> my replication queries.

Hopefully very little.

> On a related question, if Osmosis is to be viable I'll need timestamp 
> indexing so I can efficiently query for changed records within a 
> specific time period.  These are the indexes I created locally.
> ALTER TABLE `osm`.`nodes` ADD INDEX `nodes_tstamp_idx` USING 
> BTREE(`timestamp`);
> ALTER TABLE `osm`.`segments` ADD INDEX `segments_tstamp_idx` USING 
> BTREE(`timestamp`);
> ALTER TABLE `osm`.`ways` ADD INDEX `ways_tstamp_idx` USING 
> BTREE(`timestamp`);
>
> Is there any way I can submit these for inclusion on the primary database?

Well those tables have already been migrated though I certainly could
update them again to add those indexes and add them to the migration
before I commit it. It looks like each index takes about 15 minutes to
add so adding them isn't a major headache but would need to have some
downtime scheduled so it may be best to do it now.

Tom

-- 
Tom Hughes (tom at compton.nu)
http://www.compton.nu/