query performance improvements on column tables
To querying on observations columns table et retrieve foreign datas (species, observers, places, etc.), we need to join foreign data with both site
and id
. eg:
select * from observations as o left join species s on (o.site, o.id_species) = (s.site, s.id)
Adding btree indexes on (site, id)
on attribute tables improve performances.