Postgres Pro
Downloads
Home   >   mailing lists

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

From Josh Berkus
Subject Re: Join slow on "large" tables
Date
Msg-id 200406071531.49207.josh@agliodbs.com
Whole thread Raw
In response to Join slow on "large" tables  (Josué Maldonado <josue@lamundial.hn>)
Responses Re: Join slow on "large" tables
List pgsql-performance
Tree view 
Josue'

>     ->  Index Scan using pkd_pcode_idx on pkardex  (cost=0.00..11292.52
> rows=5831 width=72) (actual time=18.152..39520.406 rows=5049 loops=1)

Looks to me like there's a problem with index bloat on pkd_pcode_idx.   Try
REINDEXing it, and if that doesn't help, VACUUM FULL on pkardex.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco

pgsql-performance by date:

Previous
From: Josué Maldonado
Date:
Subject: Join slow on "large" tables
Next
From: "Scott Marlowe"
Date:
Subject: Re: Join slow on "large" tables