id,summary,reporter,owner,description,type,status,priority,milestone,component,version,resolution,keywords,cc 796,Don't create indexes on primary key columns for tables in the dynamic database,Nicklas Nordborg,Nicklas Nordborg,"The performance testing (#294) discovered that a lot of indexes are created in the dynamic database. It seems redundant since the columns are already part of the primary key of the table(s). Initial tests shows that removing the indexes, increases the performance by a factor of 2-10. Additional tests may be needed. * Extend the tests to larger data sets * Make sure nothing bad happens if using Postgres If we find that it is safe to remove the indexes a utility for removing them from already existing tables must be created.",enhancement,closed,critical,BASE 2.4.4,core,,fixed,,