Re: Join slow on "large" tables

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Josué Maldonado <josue(at)lamundial(dot)hn>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Join slow on "large" tables
Date: 2004-06-07 22:31:49
Message-ID: 200406071531.49207.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2004-06-07 22:47:12 Re: Join slow on "large" tables
Previous Message Josué Maldonado 2004-06-07 22:19:22 Join slow on "large" tables