how to reduce Xidgenlock wait event

[Ishan Joshi <Ishan.Joshi@xxxxxxxxxx>]

Hi Team,

 

We have been observing XidGenlock wait in our transaction. This leeads some perofmrance issue in our product. We have heavyly commit product but still we are not getting such wait during the time. We have increase our load to double and then it start getting it. I have check the transaction id is not getting reached to the max size.

 

I am using AWS RDS instance and we have autovacuum on on this RDS. Plese find  parameter as follows.

Please let me know who to reduce such wait event with tunning of some parameters.

 

autovacuum	on
autovacuum_analyze_scale_factor	0
autovacuum_analyze_threshold	1000
autovacuum_freeze_max_age	200000000
autovacuum_max_workers	20
autovacuum_multixact_freeze_max_age	10000000
autovacuum_naptime	10
autovacuum_vacuum_cost_delay	0
autovacuum_vacuum_cost_limit	-1
autovacuum_vacuum_scale_factor	0.1
autovacuum_vacuum_threshold	1000
checkpoint_completion_target	0.9
cpu_tuple_cost	0.03
effective_cache_size	23592960 (180 GB)
seq_page_cost	0.7
shared_buffers	64GB
temp_buffers	16384
vacuum_cost_delay	0
vacuum_cost_limit	6000
vacuum_cost_page_dirty	20
vacuum_cost_page_miss	5
vacuum_defer_cleanup_age	0
vacuum_freeze_min_age	10000
vacuum_freeze_table_age	20000
vacuum_multixact_freeze_min_age	10000
vacuum_multixact_freeze_table_age	20000
wal_buffers	262143
wal_keep_segments	400
work_mem	18432

 

 

Thanks & Regards

Ishan Joshi

 

This email and the information contained herein is proprietary and confidential and subject to the Amdocs Email Terms of Service, which you may review at https://www.amdocs.com/about/email-terms-of-service