Claudio Freire writes:
> CREATE OR REPLACE VIEW member_all_tags_v AS
> SELECT member_tags.member_id, member_tags.last_modification_date,
> member_tags.polarity, member_tags.tag_id, 'mr' AS source
>FROM member_tags
> UNION ALL
> SELECT member_profile_tags.member_id,
>
On Mon, Mar 14, 2011 at 12:46 PM, Claudio Freire wrote:
> On Mon, Mar 14, 2011 at 2:34 PM, Merlin Moncure wrote:
>> changes to:
>>
>> SELECT member_statistics.member_id
>> FROM member_statistics
>> WHERE EXISTS
>> (
>> SELECT mat1.tag_id
>> FROM member_
On Mon, Mar 14, 2011 at 10:54 AM, Claudio Freire wrote:
> Nothing?
>
> No ideas?
>
> Did I forget to include some useful bit?
>
> On Fri, Mar 4, 2011 at 8:22 PM, Claudio Freire wrote:
>> Hello, first post to this list.
>>
>> I have this query that ran in milliseconds in postgres 8.3.7 (usually 50
Nothing?
No ideas?
Did I forget to include some useful bit?
On Fri, Mar 4, 2011 at 8:22 PM, Claudio Freire wrote:
> Hello, first post to this list.
>
> I have this query that ran in milliseconds in postgres 8.3.7 (usually 50,
> 100ms), and now it takes a full 10 minutes to complete.
>
> I track
