Database or table partitioning for performance benefits | Community
Skip to main content
H
HarshalTe
Level 3
January 10, 2022
Solved

Database or table partitioning for performance benefits

  • January 10, 2022
  • 2 replies
  • 2083 views

Hi guys,

We all know database partitioning helps on the performance front.  I'm keen to know if anyone has implemented DB or table level partitioning in a completely hosted ACC environment and what are/were the challenges that got in the way.

 

-wALF

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Stephen_Dupre_Adobe

HI wALF


It seems like you may be hosted by Adobe (not on-premise).   We would need to look at your setup, h/w, data retention, whether you're talking about our OOTB tables or custom tables, the PostgreSQL class size and autovacuum rules - and the whole PostgreSQL setup - holistically.   Then, do the tuning.   

Regards

 

Stephen Dupre
Sr. Cloud Infrastructure Engineer, Adobe Campaign

2 replies

Jyoti_Yadav
Jyoti_Yadav
Level 8
January 10, 2022

Hi @harshalte ,

 

Database partitioning is at DB level and for hosted environment it will be done by Adobe Support.

You go through below links to know more  on best practices.

Adobe Campaign Classic data model best practices

Best practices for performance improvement on Campaign Classic

 

Thanks,

Jyoti

    H
    HarshalTeAuthor
    Level 3
    January 11, 2022

    Thanks Joyti.  Although the second link wasn't accessible, the first one summarizes some good tips that can be helpful.  I can now check with Adobe Support for I was particularly looking for database partitioning.  Before we could consider, I wanted to have a clear understanding on the benefits vs. efforts of doing so.

     

    -wALF

    H
    HarshalTeAuthor
    Level 3
    January 18, 2022

    Turns out there is not a single customer using partitioned Postgres database.  Sadly, Adobe support says this is something that isn't supported by ACC as there are no cases available to answer our queries.

    Is there a way we could raise an exception request so they can try this out on their local sandbox to confirm this works well compared to un-partitioned data?  Just trying to get partitioning certified by Adobe.

     

    -wALF

    Stephen_Dupre_Adobe
    Adobe Employee
    Stephen_Dupre_AdobeAdobe EmployeeAccepted solution
    Adobe Employee
    January 21, 2022

    HI wALF


    It seems like you may be hosted by Adobe (not on-premise).   We would need to look at your setup, h/w, data retention, whether you're talking about our OOTB tables or custom tables, the PostgreSQL class size and autovacuum rules - and the whole PostgreSQL setup - holistically.   Then, do the tuning.   

    Regards

     

    Stephen Dupre
    Sr. Cloud Infrastructure Engineer, Adobe Campaign

      H
      HarshalTeAuthor
      Level 3
      January 27, 2022

      Hi Stephen,

       

      Yes, we're completely hosted and although we're not running into massive performance issues but we were thinking if DB partitioning helps boost the performance a bit more, why not.  Your response makes a whole lot of sense and I totally agree.  This query was raised just to gain insights and understand the efforts vs. benefits. 

       

      We'd be interested with just the custom tables, tbh.  We've been informed Postgres is hosted on RDS and hence not possible but an internal ENH has been raised by Adobe to officially support this, as I understand it.  

       

      -wALF

        Terms & ConditionsAccessibility statement

        Loading footer...