Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Primo

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Primo
    3. Knowledge Articles
    4. P_PNX table seems to grow when re-run normalization

    P_PNX table seems to grow when re-run normalization

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Primo
    • Product Version: 2

    Description:
    We have been doing renormalization over the same set of records as we tweak our normalization rules. The source record count stays the same - this is as should be since we are just normalizing the exact same set of records.

    What is odd is that after each normalization, the PNX counts go up by about the same amount and that amount is exactly equal to the number of new dedup and frbr records. It looks like Primo is adding the total of FRBRs and Dedups into the PNX database instead of overlaying the existing ones and if we continue to renormalize, the PNX database is going to artificially bloat.

    Is this behavior a bug, expected, other? If it is expected, why isn't the PNX database being cleaned up?

    Resolution:
    When data is reloaded, the system deletes the FRBR and dedup records that were previously created for the single updated records. The delete is not physical (logical) and therefore the P_PNX table grows by the amount of FRBR and dedup records.

    If you want to start from scratch or avoid growth of P_PNX, you may run the clean_data_all.sh script which will remove the data and the indexes.

    Additional Information

    dedup, frbr, p_pnx, database


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • OvP: My account: Long lists of loans are not displayed
      • Palo Alto virus warning
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Community Content Type
      How To
      Content Type
      Knowledge Article
      Language
      English
      Product
      Primo
    2. Tags
      1. 2
      2. contype:kba
      3. Prod:Primo
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved