On Tue, Sep 3, 2013 at 8:48 AM, ascot.moss@xxxxxxxxx <ascot.moss@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
