Re: Slow query

From: Oleg Lebedev <oleg(dot)lebedev(at)waterford(dot)org>
To: Josh Berkus <josh(at)agliodbs(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Slow query
Date: 2003-03-24 19:02:51
Message-ID: 993DBE5B4D02194382EC8DF8554A5273113E5C@postoffice.waterford.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

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

Browse pgsql-performance by date

  From Date Subject
Next Message Stephan Szabo 2003-03-24 19:03:42 Re: Slow query
Previous Message Josh Berkus 2003-03-24 18:54:49 Re: Slow query