On Wed, Oct 20, 2010 at 11:05 PM, Tim Uckun <timuckun@xxxxxxxxx> wrote: >> >> No, it isn't. This is a three-way join between consolidated_urls, cu, >> and tu --- the fact that cu is the same underlying table as > > cu is an alias for consolidated_urls. tu is an alias for trending_urls. > > There are only two tables in the query. What does explain update (your query continues) say about it? I'm betting you get a nice big row count in there somewhere. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
