Re: pg_buffercache's usage count

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_buffercache's usage count
Date: 2010-02-23 22:11:01
Message-ID: 95AA0CCF-E226-4A4C-83DF-2FCDFA639B36@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Feb 23, 2010, at 3:06 PM, Ben Chobot wrote:

> 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?

(And maybe more to the point, when does the LRU go down in value?)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message raf 2010-02-24 01:07:50 select t.name from tbl t (where "name" is not a column name)
Previous Message Ben Chobot 2010-02-23 22:06:51 pg_buffercache's usage count