Re: slow index lookup

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Anj Adu <fotographs(at)gmail(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: slow index lookup
Date: 2010-06-22 23:44:15
Message-ID: 1277250226-sup-6686@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Excerpts from Anj Adu's message of mar jun 22 17:44:39 -0400 2010:
> This query seems unreasonable slow on a well-indexed table (13 million
> rows). Separate indexes are present on guardid_id , from_num and
> targetprt columns.

Maybe you need to vacuum or reindex?

--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Anj Adu 2010-06-23 01:00:29 Re: slow index lookup
Previous Message Anj Adu 2010-06-22 21:44:39 slow index lookup