Postgres Pro
Downloads
Home   >   mailing lists

# of Index' Tuples != Heap' - Mailing list pgsql-hackers

From The Hermit Hacker
Subject # of Index' Tuples != Heap'
Date
Msg-id Pine.BSF.4.05.9907272003520.55528-100000@thelab.hub.org
Whole thread Raw
List pgsql-hackers
Tree view 
Odd...this is a v6.5.1 system...I thought we had fixed this?

hardware=> vacuum;
NOTICE:  Index products_category: NUMBER OF INDEX' TUPLES (3360) IS NOT THE SAME AS HEAP' (5355)
NOTICE:  Index products_vendor: NUMBER OF INDEX' TUPLES (5089) IS NOT THE SAME AS HEAP' (5355)
VACUUM



Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Selectivity of "=" (Re: [HACKERS] Index not used on simple select)
Next
From: Hannu Krosing
Date:
Subject: Re: Selectivity of "=" (Re: [HACKERS] Index not used on simple select)