> I've done other things that make sense, like using indexes, playing with the
> planner constants and turning up the postgres cache buffers.
After you load the new days data try running CLUSTER on the structure
using a key of (stockID, date) -- probably your primary key.
This should significantly reduce the amount of IO required for your
calculations involving a few stocks over a period of time.
In response to
- Prefetch at 2005-05-10 13:52:51 from Matt Olson
pgsql-performance by date
|Next:||From: John A Meinel||Date: 2005-05-10 14:28:54|
|Subject: Re: full outer performance problem|
|Previous:||From: Tom Lane||Date: 2005-05-10 14:16:20|
|Subject: Re: Prefetch |