=?ISO-8859-1?Q?Josu=E9_Maldonado?= <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]