=?ISO-8859-1?Q?Josu=E9_Maldonado?= <josue(at)lamundial(dot)hn> writes:
> Recreated the index (drop then create) and did the vacuum full pkardex
> and the behavior seems to be the same:
Well, there was a pretty huge improvement in the pkardex scan time,
whether you noticed it or not: 39520.406 to 87.393 msec. This
definitely suggests that you've been lax about vacuuming this table.
I'm wondering whether pmdoc might not be overdue for vacuuming as
well.
regards, tom lane