Skip to content
GitLab
  • Menu
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • Client_API_VN Client_API_VN
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 29
    • Issues 29
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 0
    • Merge requests 0
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • LPOAgirPourLaBiodiversite
  • Client_API_VNClient_API_VN
  • Issues
  • #90
Closed
Open
Created Aug 28, 2019 by fred.lpo07@fred.lpo07Owner

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.

Assignee
Assign to
Time tracking