AWS Aurora for PostgreSQL strange vacuum cost parameters

Ask Question

Asked 2 years, 10 months ago

Modified 2 years, 10 months ago

Viewed 433 times

Today, I found out that in AWS Aurora for PostgreSQL 11 the default cluster parameter vacuum_cost_page_miss = 0 whereas vacuum_cost_page_hit = 1.

I'd love to understand the logic behind pricing a page miss as cheaper than a page hit.

asked Jan 21, 2021 at 21:05

Jonathan Jacobson

2812 silver badges7 bronze badges

Add a comment |

0 Your Answer

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.