On Wed, 21 Apr 2004, Merlin Moncure wrote:
>
> > Perhaps one of the advocay team will pick up the batton?
> He is using COPY to load the data...I can't think of any earthly reason
> why it takes > 1d to load 10gb data...probabaly all boils down to
> default shared buffer setting. I don't even really consider this
> 'optimizing', just basic configuring to match the software to the
> machine.
The indexes should be created after the data is loaded. There is no
mention of VACUUM, ANALYZE or tuning.
I've generated the work load over night and am going to have a quick look
at it when I get a minute.
Gavin