Re: faster way to calculate top "tags" for a "resource" based on a column

From: Jonathan Vanasco <postgres(at)2xlp(dot)com>
To: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: faster way to calculate top "tags" for a "resource" based on a column
Date: 2014-10-06 23:07:35
Message-ID: 9CCEB3B9-F024-4860-B97D-A453887F1A07@2xlp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Oct 6, 2014, at 5:56 PM, Jim Nasby wrote:

> Don't join to the resource table; there's no reason to because you're not pulling anything from it.

Thanks the reply!

I'm not pulling anything from the resource table, but the join is necessary because I'm filtering based on it. ( see the WHERE clause )

I'm not trying to find the most used overall tags, but the ones that are used by resources with a (variable) id on a column in the resources table. .

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gavin Flower 2014-10-06 23:10:08 Re: table versioning approach (not auditing)
Previous Message Melvin Davidson 2014-10-06 22:49:25 Re: Converting char to varchar automatically