1

if PostgreSQL loads something (for example an index) into cache, what happens if it (cached index) gets modified? Is it going to be removed from cache or not?

1 Answer 1

4

If by cache you mean shared_buffers, no, it won't be removed from there due to being changed. shared_buffers is the primary place where it does get changed. From there it will eventually get pushed out to the kernel, and then from there to disk.

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.