vacuum messages

From: David Shrewsbury <shrews(at)lssi(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: vacuum messages
Date: 2000-08-18 15:47:19
Message-ID: 399D5A87.9230B3B7@lssi.NOSPAM.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm getting the following output from a vacuum:

NOTICE: Index reports_pkey: NUMBER OF INDEX' TUPLES (26280) IS NOT THE
SAME AS HEAP' (26279)
NOTICE: Index reports_pkey: NUMBER OF INDEX' TUPLES (26280) IS NOT THE
SAME AS HEAP' (26279)

I read somewhere on the Internet that the best way to fix this is to
drop the index and recreate it. Not having much experience with
databases,
I'm afraid to do this for fear of screwing up the db. The index was
created automatically when I created the table so I'm not sure of the
proper way to recreate it. Can someone provide me with details of how
to do this properly? Will it do any harm to leave it as is? If it helps,
here is the definition of the index:

discrepancy=> \d reports_pkey
Table = reports_pkey
+----------------------------------+----------------------------------+-------+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-------+
| tracking_num | int4
| 4 |
+----------------------------------+----------------------------------+-------+

Thanks,
David

Browse pgsql-general by date

  From Date Subject
Next Message Alfred Perlstein 2000-08-18 16:17:15 Re: VERY SLOW UPDATES
Previous Message Sevo Stille 2000-08-18 14:07:21 Re: Renaming database