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.