Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> writes:
> and after vacuum analyze:
> -rw------- 1 postgres users 8192 Jul 27 18:54 hits
> -rw------- 1 postgres users 1703936 Jul 27 18:54 hits_pkey
> Why hits_pkey is so big ? I have only 7 rows in the table.
Looks like vacuum reclaims the extra space in the table itself,
but does not do so with indexes. Ugh.
I've thought for some time that vacuum ought to drop and rebuild
indexes instead of trying to update them. This might be another
reason for doing that...
regards, tom lane