Re: Unused indexes - PostgreSQL 9.2

On 11 May 2016 at 09:06, 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
>

Also.. just to let you guys know:

Some time ago I changed the pg_stat_temp directory from
/var/lib/pgsq/whatever to /tmp

postgresql.conf:

> stats_temp_directory = '/tmp/pg_stat_tmp'

I tested it and it's "working":

> #su - postgres
> #cd /tmp/pg_stat_tmp
> #touch test.html

ls -la /tmp/pg_stat_tmp:

> -rw------- 1 postgres postgres 263110 May 10 21:12 pgstat.stat