Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-13097

Slow chunks on full-sky Object self-join with Qserv

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Invalid
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: Qserv
    • Labels:
      None
    • Story Points:
      4
    • Team:
      Data Access and Database

      Description

      During testing for DM-10515 we found that full sky near-neighbor join queries were taking very long (~30 minutes) on a per chunk basis. The query we ran was:

      select count(*) from Object o1, Object o2 where o1.deepSourceID <> o2.deepSourceID and scisql_angSep(o1.ra, o1.decl, o2.ra, o2.decl) < 0.015

      This seems to be unintended behavior that needs investigation.

        Attachments

          Issue Links

          mentioned in

          Page Loading...

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            tjenness Tim Jenness added a comment -

            Fritz Mueller is this still a problem?

            Show
            tjenness Tim Jenness added a comment - Fritz Mueller is this still a problem?
            Hide
            Permalink
            fritzm Fritz Mueller added a comment -

            Full sky n.n. joins are currently working as expected.

            Show
            fritzm Fritz Mueller added a comment - Full sky n.n. joins are currently working as expected.

              People

              Assignee:
              jgates John Gates
              Reporter:
              vaikunth Vaikunth Thukral
              Watchers:
              Fritz Mueller, Nate Pease [X] (Inactive), Tim Jenness, Vaikunth Thukral
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Jenkins

                  No builds found.