Re: Slow query

No, I don't believe so.
My previous question regarding performance was solved by VACUUM FULL and
REINDEX.
The current one, I believe, is more related to query structure and
planner stats.

-----Original Message-----
From: Josh Berkus [mailto:josh(at)agliodbs(dot)com]
Sent: Monday, March 24, 2003 11:55 AM
To: Oleg Lebedev; pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] Slow query

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

*************************************

This email may contain privileged or confidential material intended for the named recipient only.
If you are not the named recipient, delete this message and all attachments.
Any review, copying, printing, disclosure or other use is prohibited.
We reserve the right to monitor email sent through our network.

*************************************