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: My index doesn't write anymore but read
Date: 2015-05-18 06:06:54
Message-ID: 1431929214209-5849689.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

We have a large database with postgre 9.3 (>300 Gb) and our queries are
(really) long for 6 days without changing anything.

After seeing our log, I saw that the same query on an old data was quick but
the same query with new data are really slow.
Let me show you a sample of my query on my table (>50 Gb):

Here, the query is really speed, less than 100 ms, thanks to the index on
date.

With this query, and the date after the 17th, the query is really slow (>10
000 ms)

How can we resolve that ?
A VACUUM FULL maybe ?
Why my index doesn't work for "new" data ?

Notice : we are working on SSD and the partition has space.

Thanks a lot for your help.

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2015-05-18 06:32:23 Re: My index doesn't write anymore but read
Previous Message William Dunn 2015-05-18 00:57:12 Re: