Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group