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.
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: |