Re: My index doesn't write anymore but read

Поиск
Список
Период
Сортировка
От ben.play
Тема Re: My index doesn't write anymore but read
Дата
Msg-id 1433163479922-5852012.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: My index doesn't write anymore but read  (William Dunn <dunnwjr@gmail.com>)
Список pgsql-general
Дерево обсуждения 
Thank your William for your help.
After 1 week, I do not see any improvement. Worse, I have to manually run
"ANALYSE" daily.
Here is my config :



My bloat for this table is 1.04151.
What does it mean exactly ?

Why do we have to analyse the table daily ? Is it normal ?

Thank you so much for your help !



--
View this message in context:
http://postgresql.nabble.com/My-index-doesn-t-write-anymore-but-read-tp5849689p5852012.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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

Предыдущее
От: Francisco Olarte
Дата:
Сообщение: Re: Efficient sorting the results of a join, without denormalization
Следующее
От: Rishi Gokhale
Дата:
Сообщение: Re: date type changing to timestamp without time zone in postgres 9.4