Re: [SQL] performance problems of a complex query with 2 subselects

> 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.