Re: Unused indexes - PostgreSQL 9.2

Поиск
Список
Период
Сортировка
От Lucas Possamai
Тема Re: Unused indexes - PostgreSQL 9.2
Дата
Msg-id CAE_gQfUShrBC6XHdKeF3WDxfveyNJN8=xAw64wtX-oPHjPtyNQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Unused indexes - PostgreSQL 9.2  (Lucas Possamai <drum.lucas@gmail.com>)
Список pgsql-general
Дерево обсуждения


On 11 May 2016 at 09:06, Lucas Possamai <drum.lucas@gmail.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

В списке pgsql-general по дате отправления:

Предыдущее
От: Lucas Possamai
Дата:
Сообщение: Re: Unused indexes - PostgreSQL 9.2
Следующее
От: Melvin Davidson
Дата:
Сообщение: Re: Unused indexes - PostgreSQL 9.2