Oleg,
> Please help me speed up the following query. It used to run in 2-5 sec.,
> but now it takes 2-3 mins!
> I ran VACUUM FULL ANALYZE and REINDEX.
> SELECT * FROM media m
> WHERE m.mediatype = (SELECT objectid FROM mediatype WHERE
This is a repost, isn't it?
--
Josh Berkus
Aglio Database Solutions
San Francisco