Uploaded image for project: 'PFS observation processing/procedure'
  1. PFS observation processing/procedure
  2. OBSPROC-132

Partitioning sky and fluxstd tables by input_catalog_id or version

    XMLWordPrintable

    Details

      Description

      The sky and fluxstd tables have more than billion rows. For such large tables, a single table is likely to have performance and maintenance issues. 

       

      I'd like to implement partitioning to split sky and fluxstd table by either input_catalog_id or version. The former is recommended as integer is easier to handle, while the current pointing optimization code queries calibration objects by versions (as far as I understand). 

       

      Even after the partitioning, Q3C indexes will work.

        Attachments

          Activity

            People

            • Assignee:
              monodera monodera
              Reporter:
              monodera monodera
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: