Postgresql Index caching

Question

Some question regarding indexing in PostgreSQL ->

Does index creation saved in buffer cache?
If it is saved so will it removed considering LRU?
If is it not saved in the buffer cache, so where are those saved?

Laurenz Albe · Accepted Answer · 2021-03-29 06:48:57Z

1

Indexes, like tables, are persisted in data files on disk. 8kB blocks that are used get loaded into cache and remain there until the space is needed for something else. If the cache is big enough and the index is used often enough, it will stay cached.

answered Mar 29, 2021 at 6:48

Laurenz Albe

257k22 gold badges314 silver badges390 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql Index caching

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related