Postgres Pro
Downloads
Home   >   mailing lists

Re: faster way to calculate top "tags" for a "resource" based on a column - Mailing list pgsql-general

From Jonathan Vanasco
Subject Re: faster way to calculate top "tags" for a "resource" based on a column
Date
Msg-id 9CCEB3B9-F024-4860-B97D-A453887F1A07@2xlp.com
Whole thread Raw
In response to Re: faster way to calculate top "tags" for a "resource" based on a column  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-general
Tree view 
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
theWHERE 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
columnin the resources table. .

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: Converting char to varchar automatically
Next
From: Gavin Flower
Date:
Subject: Re: table versioning approach (not auditing)