Oleg,
> I VACUUM ANALYZED both databases and made sure they have same indexes on
> the tables.
Have you VACUUM FULL the main database? And how about REINDEX?
> Here is the query:
> SELECT * FROM media m, speccharacter c
> WHERE m.mediatype IN (SELECT objectid FROM mediatype WHERE
> medianame='Audio')
The above should use an EXISTS clause, not IN, unless you are absolutely sure
that the subquery will never return more than 12 rows.
--
Josh Berkus
Aglio Database Solutions
San Francisco