Re: [PERFORM] Bottleneck?

Hi Scott, Yes I did that. And you are right because I restart my machine, so the postgres cache is empty. And I think postgresql is reading all 1.8GB of data back into the cache when it does a seq scan on the status table. QUERY PLAN

Re: [PERFORM] Bottleneck?

Is this alright? QUERY PLAN --- Sort (cost=390162.53..390162.54 rows=3 width=567) (actual time=106045.453..106

Re: [PERFORM] Bottleneck?

Sorry post again. QUERY PLAN --- Sort (cost=390162.53..390162.54 rows=3 width=567) (actual time=105726.803..105