On Sat, Mar 17, 2012 at 2:56 PM, Robert Poor wrote:
> Disclaimer: this is a re-post, since I wasn't subscribed the first
> time I posted. Pardon if this is a duplicate.]
>
> The following query is abysmally slow (e.g. 7 hours+). The goal is to
> find "among the users that follow user #1, who do
Disclaimer: this is a re-post, since I wasn't subscribed the first
time I posted. Pardon if this is a duplicate.]
The following query is abysmally slow (e.g. 7 hours+). The goal is to
find "among the users that follow user #1, who do they also follow?"
and to count the latter.
SELECT L2.foll
Andy Colson wrote:
On 03/16/2012 05:30 PM, Kevin Grittner wrote:
>> Ah, I didn't pick up on the attempts at humor; perhaps that's why
>> you mistook something I said as an attempt at an insult.
>
> It wasn't you Kevin, it was me that insulted him. (Although I was
> trying to be funny, and not me
On 03/16/2012 05:30 PM, Kevin Grittner wrote:
Brian Hamlin wrote:
On Mar 16, 2012, at 7:17 AM, Kevin Grittner wrote:
Andy Colson wrote:
I tried shared_buffers at both 2400M and 18000M, and it took 4.5
hours both times. ... (weak attempts at humor omitted)
Ah, I didn't pick up on the