Re: Slow query

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

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

In response to

  • Slow query at 2003-03-24 17:48:52 from Oleg Lebedev

Browse pgsql-performance by date

  From Date Subject
Next Message Oleg Lebedev 2003-03-24 19:02:51 Re: Slow query
Previous Message Oleg Lebedev 2003-03-24 17:48:52 Slow query