Re: slow index lookup

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I did post the explain analyze..can you please clarify

On Tue, Jun 22, 2010 at 6:10 PM, Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx> wrote:
> On Tue, 2010-06-22 at 18:00 -0700, Anj Adu wrote:
>> i have several partitions like this (similar size ...similar data
>> distribution)..these partitions are only "inserted"..never updated.
>> Why would I need to vacuum..
>>
>
> An explain analyze is what is in order for further diagnosis.
>
> JD
>
>
>> I can reindex..just curious what can cause the index to go out of whack.
>>
>> On Tue, Jun 22, 2010 at 4:44 PM, Alvaro Herrera
>> <alvherre@xxxxxxxxxxxxxxxxx> wrote:
>> > 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@xxxxxxxxxxxxxxxxx>
>> > The PostgreSQL Company - Command Prompt, Inc.
>> > PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>> >
>>
>
> --
> PostgreSQL.org Major Contributor
> Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
> Consulting, Training, Support, Custom Development, Engineering
>
>

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux