Re: [PERFORM] Slow performance when querying millions of rows

2011-06-28 Thread Craig McIlwee
> On 06/28/2011 05:28 PM, Craig McIlwee wrote: > > Autovacuum is disabled for these tables since the data is never > > updated. The tables that we are testing with at the moment will not > > grow any larger and have been both clustered and analyzed. > > Note that

Re: [PERFORM] Slow performance when querying millions of rows

2011-06-28 Thread Craig McIlwee
> Dne 28.6.2011 23:28, Craig McIlwee napsal(a): > > Daily table explain analyze: http://explain.depesz.com/s/iLY > > Half month table explain analyze: http://explain.depesz.com/s/Unt > > Are you sure those two queries are exactly the same? Because the daily > case outp

[PERFORM] Slow performance when querying millions of rows

2011-06-28 Thread Craig McIlwee
Hello, I have a handful of queries that are performing very slowly.  I realize that I will be hitting hardware limits at some point, but want to make sure Ive squeezed out every bit of performance I can before calling it quits. Our database is collecting traffic data at the rate of about 3 mill