I'm looking at the usage count column of pg_buffercache's info, and I'm confused. Several buffers that supposed have LRU values of 5 belong to non-unique indices which supposedly have never been used. As I understand things, that shouldn't happen. Am I missing something? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
- [GENERAL] pg_buffercache's usage count Ben Chobot
- Re: [GENERAL] pg_buffercache's usage count Ben Chobot
- Re: [GENERAL] pg_buffercache's usage count Greg Smith
- Re: [GENERAL] pg_buffercache's usage count Alvaro Herrera
- Re: [GENERAL] pg_buffercache's usage count Greg Smith
- Re: [GENERAL] pg_buffercache's usage ... Ben Chobot