Skip to main content
pierrec70731455
pierrec70731455
Level 4
May 22, 2019 12:05 PM UTC
Solved

Vaccum locking tables (Recipient)

Hi,

The Vaccuum process runs on a regular basis and we notice it sometimes blocks Update Data on tables such as Recipient and even an Enrichment activity on Recipient which is basically a select.

The Neolane Support told us :

Does anybody have any suggestion regarding this?

Can it really not be excluded during some time slots like the office hours?

Kind regards,

Pierre

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Jonathon_wodnicki
    Jonathon_wodnickiAccepted solution
    Community Advisor
    May 22, 2019 1:57 PM UTC

    Hi,

    Autovacuum? That doesn't lock tables, and afaik nothing locks read access outside alter table, truncate, vacuum full.

    Could just be an undersized db struggling with any load, I see them all the time.

    Thanks,

    -Jon

    View in thread

    2 replies

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity AdvisorAccepted solution
    Community Advisor
    May 22, 2019 1:57 PM UTC

    Hi,

    Autovacuum? That doesn't lock tables, and afaik nothing locks read access outside alter table, truncate, vacuum full.

    Could just be an undersized db struggling with any load, I see them all the time.

    Thanks,

    -Jon

    Translate
      pierrec70731455
      pierrec70731455Author
      Level 4
      May 29, 2019 7:59 AM UTC

      Hi,

      it indeed wasn't the autovaccum causing the issue.

      Kind regards,

      Pierre

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...