> You need to 'vacuum analyze <table>' for each table that you have created
> AFTER you've created the indexes for them before the sql optimizer will
> use the indexes. This should solve most of your speed issues. I also believe
> that this is in the FAQ.
I forgot to tell you, but I did do
vacuum;
vacuum analyze;
It seemed to process all tables, so I thought there was no need to
vacuum analyze individual tables.
I'll try that, thanks.
Juris.