Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Vaccum locking tables (Recipient)

pierrec70731455
Level 5
Level 5

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

1 Accepted Solution
wodnicki
Correct answer by
Community Advisor
Community Advisor

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 solution in original post

2 Replies
wodnicki
Correct answer by
Community Advisor
Community Advisor

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 solution in original post

pierrec70731455
Level 5
Level 5

Hi,

it indeed wasn't the autovaccum causing the issue.

Kind regards,

Pierre