Skip to content
GitLab
Projects Groups Topics Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Register
  • Sign in
  • H hivemind
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributor statistics
    • Graph
    • Compare revisions
  • Issues 75
    • Issues 75
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 11
    • Merge requests 11
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages and registries
    • Packages and registries
    • Package Registry
    • Container Registry
    • Terraform modules
  • 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
  • hivehive
  • hivemind
  • Merge requests
  • !460

WIP: [DLN] testing use of PARALLEL SAFE for a bunch of get_ functions

  • Review changes

  • Download
  • Patches
  • Plain diff
Open Dan Notestein requested to merge dn_parallel_safe into develop Jan 11, 2021
  • Overview 4
  • Commits 1
  • Pipelines 2
  • Changes 18

Testing usage of PARALLEL SAFE to see if it improves performance (and testing to be sure it doesn't have any negative effects).

I decided it was probably safe to set "PARALLEL SAFE" on functions containing CTEs, despite vague messaging in Postgres manual, based on this discussion: https://www.postgresql.org/message-id/CAGHENJ6dF12ewNS%3DbrvGfafi8tPu6WQ2usati7Occqni-htSnw%40mail.gmail.com

Anyways, so far it's far from clear yet whether allowing parallelizing helps or harms in our current queries in terms of performance.

Edited Jan 11, 2021 by Dan Notestein
Assignee
Assign to
Reviewers
Request review from
Time tracking
Source branch: dn_parallel_safe