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