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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general