> 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?
Aglio Database Solutions
In response to
- Slow query at 2003-03-24 17:48:52 from Oleg Lebedev
pgsql-performance by date
|Next:||From: Oleg Lebedev||Date: 2003-03-24 19:02:51|
|Subject: Re: Slow query|
|Previous:||From: Oleg Lebedev||Date: 2003-03-24 17:48:52|
|Subject: Slow query|