Re: Join slow on "large" tables - Mailing list pgsql-performance

From Tom Lane
Subject Re: Join slow on "large" tables
Date
Msg-id 26335.1086671902@sss.pgh.pa.us
Whole thread Raw
In response to Re: Join slow on "large" tables  (Josué Maldonado <josue@lamundial.hn>)
List pgsql-performance
=?ISO-8859-1?Q?Josu=E9_Maldonado?= <josue@lamundial.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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: pl/pgsql and Transaction Isolation
Next
From: Russell Smith
Date:
Subject: Use of Functional Indexs and Planner estimates