Re: My index doesn't write anymore but read

From: "ben(dot)play" <benjamin(dot)cohen(at)playrion(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: My index doesn't write anymore but read
Date: 2015-06-01 12:57:59
Message-ID: 1433163479922-5852012.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rishi Gokhale 2015-06-01 13:04:23 Re: date type changing to timestamp without time zone in postgres 9.4
Previous Message Francisco Olarte 2015-06-01 10:27:52 Re: Efficient sorting the results of a join, without denormalization