Re: [PERFORM] Slow index scan on B-Tree index over timestamp field

2013-11-04 Thread Elliot
On 2013-11-04 16:10, Caio Casimiro wrote: Hi Neyman, thank you for your answer. Unfortunately this query runs almost at the same time: Sort (cost=4877693.98..4877702.60 rows=3449 width=20) (actual time=25820.291..25821.845 rows=1640 loops=1) Sort Key: tt.tweet_id Sort Method: quicksort

Re: [PERFORM] Slow index scan on B-Tree index over timestamp field

2013-11-04 Thread Elliot
On 2013-11-04 13:56, Kevin Grittner wrote: Caio Casimiro wrote: I have one query running at ~ 7 seconds and I would like to know if it's possible to make it run faster, once this query runs lots of time in my experiment. Buffers: shared hit=2390 read=32778 Total runtime: 24066.145 ms effec