From: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
---|---|
To: | Lucas Possamai <drum(dot)lucas(at)gmail(dot)com> |
Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Unused indexes - PostgreSQL 9.2 |
Date: | 2016-05-10 21:13:50 |
Message-ID: | CANu8FiyKeoecD2BrvvhvYudiGbZCJFvD1JoNhjdM7jdWAQs7Yw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, May 10, 2016 at 5:06 PM, Lucas Possamai <drum(dot)lucas(at)gmail(dot)com>
wrote:
>
>>>
>> My crystal ball is not working, you have a PostgreSQL version?
>>
>
> Maybe you should have a look on the subject of this email...
>
>
>>
>> in postgresql.conf are track_activities and track_counts both on?
>>
>
> yes
>
>
>>
>> Did you ANALYZE the table after you re-added the index?
>>
>
> Yes
>
>Maybe you should have a look on the subject of this email...
Sorry, I was too busy looking at the content.
Has the size / # rows changed recently? If the planner thinks it can load
all the rows faster, it will use a seqscan regardless if you have an index.
If that is the case, you can force index use by doing a
SET enable_seqscan = off
before executing the query.
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
From | Date | Subject | |
---|---|---|---|
Next Message | Lucas Possamai | 2016-05-10 21:17:17 | Re: Unused indexes - PostgreSQL 9.2 |
Previous Message | Lucas Possamai | 2016-05-10 21:13:27 | Re: Unused indexes - PostgreSQL 9.2 |