On Tue, Sep 3, 2013 at 8:48 AM, ascot.m...@gmail.com
<ascot.m...@gmail.com> wrote:
> Thanks.
>
> how about  the case as follows?
>
> idx_scan = 0 and idx_tup_read = 0 and idx_tup_fetch = 0, but
> idx_blks_read is not 0 and idx_blks_hit is not 0
> ?

Maintaining an unused index still requires its blocks to be read.

Cheers,

Jeff


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to